*Cleaning do file for school names in PRC data;
#delimit ;
*Make all text upper case;
replace school=upper(school);

*Start cleaning misspellings;
replace school=subinword(school, "UNIV", "UNIVERSITY", 1); 
replace school=subinword(school, "UNIV.", "UNIVERSITY", 1); 
replace school=subinword(school, "COL.", "COLLEGE", 1); 
replace school=subinword(school, "COL", "COLLEGE", 1); 
replace school=subinword(school, "COLL", "COLLEGE", 1); 
replace school=subinword(school, "COLL.", "COLLEGE", 1); 
replace school=subinword(school, "PHI", "PHILIPPINES", 1); 
replace school=subinword(school, "PHIL", "PHILIPPINES", 1); 
replace school=subinword(school, "PHIL.", "PHILIPPINES", 1); 
replace school=subinword(school, "INST.", "INSTITUTE", 1); 

*************************************************************************;
*A: Schools starting with A;

*ABAD SANTOS EDUCATIONAL INSTITUTE HAS BEEN CLOSED;

replace school= "ABE INTERNATIONAL BUISNESS COLLEGE- CAINTA" if inlist(school, "ABE INTERNATIONAL COLLEGE OF BUSINESS & ECONOMICS-CAINTA");

replace school="ABRA INSTITUTION OF SCIENCES AND TECH- BAGUED" if inlist(school, "ABRA STATE INSTITUTE OF SCIENCE & TECH (ABRA 1ST) - BANGUED",
				"ABRA STATE INSTITUTE OF SCIENCE & TECH.");
				
*ABRA VALLEY COLLEGE IS NOW CALLED ABRA VALLEY COLLEGES;
*ASSUMED ARRA VALLEY COLLEGE WAS TYPO AND MEANT ABRA;
replace school="ABRA VALLEY COLLEGES" if inlist(school, "ABRA VALLEY COLLEGE",
				"ARRA VALLEY COLLEGE");
				
*ABUYOG COMMUNITY COLLEGE FEW OBSERVATIONS, BUT SEEMS LEGIT;

replace school="ADAMSON UNIVERSITY" if inlist(school, "ADAMSON  UNIVERSITY");




*PHILIPPINE UNION COLLEGE IS NOW CALLED ADVENTIST UNI OF THE PHIL;
*ASSUMED ENTRIES WITHOUT CAMPUS WERE PART OF SILANG CAMPUS;
*ASSUMED UNION COLLEGE NAGA VIEW CAMPUS IS PART OF ADVEN SILANG CAMPUS-CBT left as Naga on 1/3/20;
*I INCLUDED CEBU CITY IN SILANG CAMPUS BECAUSE I FOUND IT WAS LISTED AS POSTAL ADDRESS FOR 
*SILANG CAMPUS ON OFFICIAL WEBSITE FOR SOUTHERN ASIAN PACIFIC SEVEN DAY ADVENTISTS-CBT removed Cebu on 1/3/20;
replace school="ADVENTIST UNIVERSITY OF THE PHILIPPINES- SILANG" if inlist(school, "ADVENTIST UNIVERSITY OF THE PHILIPPINES",
				"ADVENTIST UNIVERSITY OF THE PHILIPPINES - (FORMERLY PUC-SILANG)",
				"ADVENTIST UNIVERSITY OF THE PHILIPPINES-(FORMERLY PUC-SILANG",
				"ADVENTIST UNIVERSITY OF THE PHILIPPINES-(FORMERLY PUC-SILANG)",
				"PHILIPPINE UNION COLLEGE",
				"PHILIPPINE UNION COLLEGE - SILANG",
				"PHILIPPINE UNION COLLEGE-SILANG");
				
replace school="ADVENTIST UNIVERSITY OF THE PHILIPPINES- SILANG" if inlist(school, "P.U.C. - SILANG",
				"PHILIPPINE- UNION COLLEGE - SILANG");
				
*THE OTHER CAMPUS IS BAESA AND IT IS LISTED AS BAESA, CALCOOCAN;
replace school="ADVENTIST UNIVERSITY OF THE PHILIPPINES- BAESA" if inlist(school, "PHILIPPINE UNION COLLEGE-CALOOCAN",
				"PHILIPPINE UNION COLLEGE - CALOOCAN");
			
			
replace school="AGO MEDICAL & EDUCATIONAL CENTER - BCCM" if inlist(school, "AGO MED ED CTR- BCCM", 
		"AGO MEDICAL & EDUCATIONAL CENTER", 
		"AGO MEDICAL & EDUCATIONAL CENTER- BICOL CHRISTIAN COLL.OF MED",
		"AGO MEDICAL & EDUCATIONAL CENTER-BICOL CHRISTIAN COLL.OF MED",
		"AGO MEDICAL EDUCATIONAL INSTITUTE",
		"AGO MED.ICAL & EDUCATIONAL CENTER-BICOL CHRISTIAN COLL.OF MED",
		"AGO MEDICAL & EDUCATIONAL CENTER BCCM", "AGO MEDICAL & EDUCATIONAL CENTER-BICOL CHRISTIAN COLLEGE OF MED");
		
*AGUSAN COLLEGE IS NOW CALLED AGUSAN DEL SUR COLLEGE-CBT (1/3/20)-No Agusan colleges in in Agusan del Norte. Confirmed with CHED;
*replace school="AGUSAN DEL SUR COLLEGE" if inlist(school, "AGUSAN COLLEGES");
		
replace school="NORTHERN ILOILO POLYTECHNIC STATE COLLEGE" if inlist(school, "AJUY POLYTECHNIC COLLEGE");

replace school="AGO FOUNDATION COLLEGE" if inlist(school, "AGO FOUNDATION");

replace school="ABUBAKAR COMPUTER LEARNING CENTER" if inlist(school, "ABUBAKAR  COMPUTER LEARNING CENTER");

		
replace school="AKLAN CATHOLIC COLLEGE-(FOR AKLAN COLLEGE)-KALIBO" if inlist(school, "AKLAN COLLEGE", 
	"AKLAN CATHOLIC COLLEGE-KALIBO");

*AKLAN POLYTECHNIC INSTITUTE IS NOW CALLED AKLAN POLYTECHNIC COLLEGE;
replace school="AKLAN POLYTECHNIC COLLEGE" if inlist(school, "AKLAH POLYTECHNIC INSTITUTE",
				"AKLAN POLYTECHNIC INSTITUTE",
				"ARLAN POLYTECHNIC INSTITUTE");

replace school="AKLAN STATE UNIVERSITY(AKLAN S.C.A.)-BANGA" if inlist(school, "AKLAN STATE  UNIVERSITY(AKLAN  S.C.A.)-BANGA");

replace school="ALDERSGATE COLLEGE" if inlist(school, "ALDERSGATE  COLLEGE");

replace school="AMA COMPUTER COLLEGE- BAGUIO CITY" if inlist(school, "AMA COMPUTER COLLEGE-BAGUIO CITY",
	"AMA COMPUTER  COLLEGE-BAGUIO  CITY");
	
replace school="AMA COMPUTER COLLEGE- MAKATI CITY" if inlist(school, "AMA COMPUTER COLLEGE-MAKATI CITY",
	"AMA COMPUTER  COLLEGE-MAKATI  CITY");
	
replace school="AMA SCHOOL OF MEDICINE-EAST RIZAL" if inlist(school, "AMA COMPUTER COLLEGE-EAST RIZAL",
	"AMASCHOOL OF MEDICINE-EAST RIZAL");

replace school="AMA SCHOOL OF MEDICINE-MAKATI" if inlist(school, "AMA SCHOOL OF MEDICINE", 
	"AMASCHOOL OF MEDICINE-MAKATI");
	
*ANGELICUM COLLEGE IS NOW CALLED UST ANGELICUM COLLEGE;
replace school="UST ANGELICUM COLLEGE" if inlist(school, "ANGELICUM COLLEGE");

replace school="ANGELES UNIVERSITY FOUNDATION" if inlist(school, "ANGELES UNIVERSITY");

replace school="ANTIPOLO SCHOOL OF NURSING" if inlist(school, "ANTIPOLO SCHOOL OF NURSING & MIDWIFERY",
		"ANTIPOLO SCH. OF NURSING AND MIDWIFERY");
		
*AQUINAS UNIVERISTY OF LEGAZPI IS NOW CALLED UNIVERSITY OF SANTO TOMAS- LEGAZPI;
*I ASSUMED AQUINAS UNIVERSITY REFERRED TO AQUINAS UNIVERSITY OF LEGAZPI;
replace school="UNIVERSITY OF SANTO TOMAS- LEGAZPI" if inlist(school, "AOUINAS UNIVERSITY",
				"AQUINAS UNIVERSITY",
				"AQUINAS UNIVERSLTY");
				
replace school="ARAULLO UNIVERSITY" if inlist(school, "PAMANTASAN NG ARAULLO");

*THE MAIN CAMPUS IS IN MANILA AND IT IS ON LEGARDA STREET SO ASSUMED LEGARDA ENTRY REFERS TO CAMPUS IN MANILA;
*THE MAIN CAMPUS IS IN MANILA SO ASSUMED ENTRY WITHOUT CAMPUS WAS PART OF MAIN CAMPUS;
replace school="ARELLANO UNIVERSITY - MANILA" if inlist(school, "ARELLANO",
				"ARELLANO  UNIVERSITY-MANILA",
				"ARELLANO UNIV-LEGA.RD",
				"ARELLANO UNIVERSITY - LEGARDA",
				"ARELLANO UNIVERSITY- MANILA",
				"ARELLANO UNIVERSITY-MANILA",
				"ARELLANO UNIVERSITY",
				"ARELLANO-UNIVERSITY");
				
replace school="ARELLANO UNIVERSITY - MANILA" if inlist(school, "ARELLANO UNIVERSITY LEGARDA",
				"ARELLANO UNIVERSITY-LEGARDA");

replace school="ARELLANO UNIVERSITY - MALABON" if inlist(school, "ARELLANO UNIVERSITY- MALABON");
	


replace school="ARELLANO UNIVERSITY - PASAY" if inlist(school, "ARELLANO UNIVERSITY-PASAY",
		"ARELLANO UNIYERSITY-PASAY", "ARELLANO UNIVERSITY- PASAY", "ARELLANO  UNIVERSITY-PASAY");


replace school="ARELLANO UNIVERSITY - MALABON" if inlist(school, "ARELLANO UNIVERSITY-MALABON");

replace school="ARELLANO UNIVERSITY - PASIG" if inlist(school, "ARELLANO UNIVERSITY- PASIG",
		"ARELLANO UNIVERSITY-PASIG", "ARELLANO  UNIVERSITY-PASIG");

replace school="ARRIESGADO COLLEGE FOUNDATION, INC." if inlist(school, "ARRIESGADO COLLEGE FOUNDATION. INC.", 
		"ARRISGADO MATERNITY & CHILDRENS HOSP. MID. SCH. FOUND., INC.");

*ASIAN COLLEGE OF SCIENCE AND TECH IS NOW CALLED ASIAN COLLEGE;	
*ASSUMED ENTRIES WITHOUT CAMPUS WERE PART OF QC CAMPUS BECAUSE IT IS ORIGINAL CAMPUS;
*ASSUMED ASIAN COLLEGE OF ARTS AND BUSINESS WAS PART OF ASIAN COLLEGE;
replace school="ASIAN COLLEGE- QUEZON CITY" if inlist(school, "ASIAN COLLEGE OF SCIENCE & TECHNOLOGY",
				"ASIAN COLLEGE OF SCIENCE & TECHNOLOGY-QC",
				"ASIAN COLLEGE OF SCIENCE AND TECHNOLOGY",
				"ASIAN COLLEGE OF ARTS AND BUSINESS");
				
replace school="ASIAN COLLEGE- DUMAGUETE CITY" if inlist(school, "ASIAN COLLEGE OF SCIENCE & TECHNOLOGY- DUMAGUETE",
				"ASIAN COLLEGE OF SCIENCE & TECHNOLOGY-DUMAGUETE");
				
replace school="ASIAN DEVELOPMENT FOUNDATION COLLEGE" if inlist(school, "ASIAN DEVELOPMENT  FOUNDATION  COLLEGE");

*ASSUMPTION-SAPANG PALAY COLLEGE IS NOW CALLED SANTO ROSARIO SAPANG PALAY COLLEGE;
replace school="SANTO ROSARIO SAPANG PALAY COLLEGE" if inlist(school, "ASSUMPTION-SAPANG PALAY COLLEGE");
		
replace school="ATENEO DE ZAMBOANGA" if inlist(school, "ATENEO DE", 
		"ATENEO OE ZAMBOANGA");

replace school="ATENEO DE DAVAO UNIVERSITY" if inlist(school, "ATENEO DE DAVAO UNIVERSITY-DAVAO CITY"
		"ATENEO DE DAVAO UNIVERSTITY",
		"ATENEO DE DAVAO UNIVERSTITY",
		"ATENEO DE DAVAO BRANCH-COMPOSTELLA");

replace school="ATENEO DE NAGA UNIVERSITY" if inlist(school, "ATENEO DE NAGA");

replace school="XAVIER UNIVERSITY" if inlist(school, "ATENEO DE CAGAYAN",
		"XAVIER UNIVERSITY (FORMERLY ATENEO DE CAGAYAN)", 
		"XAVIER UNIVERSITY ATENEO DE CAGAYAN");
		
replace school="UNIVERSITY OF SAINT LOUIS-TUGUEGARAO" if inlist(school, "UNIVERSITY OF SAINT LOUIS- TUGUEGARAO",
		"ATENEO DE TUGUEGARAO");

replace school="BACARRA MEDICAL CENTER SCHOOL OF MIDWIFERY" if inlist(school, "BACARRA MEDICAL CENTER SCHOOL OF MID. & COLLEGE OF NRSG.",
		"BACARRA MEDICAL CENTER SCHOOL OF MIDWIFERY & COLLEGE OF NURSING", 
		"BACARRA MEDICAL CENTER SCHOOL OF MIDWIFERY & COLLEGE OF NURSING");

*************************************************************************;
*B: Schools starting with B;
*B: Schools starting with B;

*BATAAN NATIONAL AGRICULTURAL SCHOOL & BATAAN STATE COLLEGE & BATAAN TEACHERS COLLEGE each belong to one of the 3 bataan peninsula state university campuses, but not sure which one*;

replace school="BATAAN HEROES MEMORIAL COLLEGE" if inlist(school, "HEROES MEMORIAL COLLEGES");
				
replace school="BATAAN POLYTECHNIC STATE COLLEGE-ORANI" if inlist(school, "BATAAN POLYTECHNIC STATE COLLEGE -ORANI");
				
replace school="BATAAN PENINSULA STATE UNIVERSITY - MAIN CAMPUS" if inlist(school, "BATAAN PENINSULA STATE UNIVERSITY - BALANGA",
				"BATAAN PENINSULA STATE COLLEGE- BALANGA (BATAAN POLY.SC)",
				"BATAAN PENINSULA STATE COLLEGE-BALANGA (BATAAN POLY.SC)",
				"BATAAN PENINSULA STATE UNIVERSITY- BALANGA (FOR.BATAAN P.S)",
				"BATAAN PENINSULA STATE UNIVERSITY-BALANGA",
				"BATAAN PENINSULA STATE UNIVERSITY-BALANGA (FOR.BATAAN P.S)",
				"BATAAN POLYTECHNIC STATE COLLEGE - BALANGA");
				
replace school="BATAAN PENINSULA STATE UNIVERSITY - MAIN CAMPUS" if inlist(school, "BATAAN POLYTECHNIC STATE COLLEGE-BALANGA",
				"BATAAN POLYTECHNIC STATE COLLEGE - BALANGA",
				"BATAAN PENINSULA STATE COLLEGE- BALANGA (BATAAN POLY.SC)",
				"BATAAN PENINSULA STATE COLLEGE-BALANGA (BATAAN POLY.SC)");
											
replace school="BATAAN PENINSULA STATE UNIVERSITY - MAIN CAMPUS" if inlist(school, "BATAAN PENINSULA STATE U- MAIN CAMPUS(FOR BNSAT)",
				"BATAAN PENINSULA STATE U-MAIN CAMPUS(FOR BNSAT)",
				"BATAAN POLYTECHNIC STATE COLLEGE (FORMERLY BATAAN COLLEGES)",
				"BATAAN POLYTECHNIC STATE COLLEGE(FORMERLY BATAAN COLLEGES)",
				"BATAAN COLLEGES (FORMERLY BATAAN COMMUNITY COLLEGE)", 
				"BATAAN COLLEGES (FORMERLY BATAAN COMMUNITY COLLEGES)",
				"BATAAN COLLEGE (FORMERLY BATAAN COMMUNITY COLLEGE)",
				"BATAAN NATIONAL SCHOOL OF ARTS & TRADES");
				
*BATAAN NATIONAL AGRICULTURE SCHOOL IS NOW ABUAY CAMPUS OF BATAAN PENNISULA STATE UNIVERSITY;
replace school= "BATAAN PENNISULA STATE UNIVERSITY- ABUCAY CAMPUS" if inlist(school, "BATAAN NATIONAL AGRICULTURAL SCHOOL");

*BATAAN TEACHERS COLLEGE IS NOW CALLED BATAAN PENNISULA STATE UNIVERSITY- DINALUPIHAN CAMPUS;
*BATAAN STATE COLLEGE IS NOW CALLED BATAAN PENNISULA STATE UNVERSITY- DINALUPIHAN CAMPUS;
replace school="BATAAN PENNISULA STATE UNIVERSITY- DINALUPIHAN CAMPUS" if inlist(school, "BATAAN TEACHERS COLLEGE",
				"BATAAN STATE COLLEGE");

*BATAAN POLYTECHNIC STATE COLLEGE- ORANI IS NOW CALLED BATAAN PENNISULA STATE UNIVERSITY- ORNAMI CAMPUS;
replace school= "BATAAN PENNISULA STATE UNIVERSTIY- ORANI CAMPUS" if inlist(school, "BATAAN POLYTECHNIC STATE COLLEGE-ORANI");				
				
replace school = "BROKENSHIRE COLLEGE" if inlist(school, "BROKEHSHIRE COLLEGE", 
				"BROKENSHIRE  COLLEGE",  
				"BROKENSHISE COLLEGE");
				
replace school = "BROKENSHIRE COLLEGE-SOCSKSARGEN, INC" if inlist(school, "BROKENSHIRE COLLEGE- SOCSKSARGEN, INC");

replace school="BACARRA MEDICAL CENTER SCHOOL OF MIDWIFERY" if inlist(school, "BACARRA MEDICAL CENTER SCHOOL OF MID. & COLLEGE OF NRSG.",
		"BACARRA MEDICAL CENTER SCHOOL OF MIDWIFERY & COLLEGE OF NURSING", 
		"BACARRA MEDICAL CENTER SCHOOL OF MIDWIFERY & COLLEGE OF NURSING");

replace school="BAGUIO COLLEGE FOUNDATION" if inlist(school, "BAGUIO COLLEGES FOUNDATION");

replace school="BAGUIO GENERAL HOSPITAL" if inlist(school, "BAGUIO CENERAL HOSPITAL");

replace school="BUTUAN CITY COLLEGES" if inlist(school, "8UTUAN CITY COLLEGES");

replace school="BALIUAG COLLEGE" if inlist(school, "BALIUAG COLLEGES");

*BUKIDNON STATE COLLEGE IS NOW CALLED BUKIDNON STATE UNIVERSITY;
replace school="BUKIDNON STATE UNIVERSITY" if inlist(school, "BUKIDNON STATE  COLLEGE-  MALAYBALAY",
				"BUKIDNON STATE COLLEGE",
				"BUKIDNON STATE COLLEGE- MALAYBALAY",
				"BUKIDNON STATE COLLEGE-MALAYBALAY");

replace school="BUTUAN DOCTORS' COLLEGE" if inlist(school, "BUTUAN DOCTOR'S COLLEGE",
				"BUTUAN DOCTORS COLLEGE",
				"BUTUAN D'OC'TORS HOSPITAL SCHOOL OF NURSING",
				"BUTUAN DOCTORS COLLEGE (BUTUAN DR. HSP. SCH. OF NRSNG)",
				"BUTUAN DOCTORS COLLEGE (BUTUAN DR. HSP. SCH. OF NRSNG.)",
				"BUTUAN DOCTORS COLLEGE(BUTUAN DR. HSP. SCH. OF NRSNG.)",
				"BUTUAN DOCTORS HOSP",
				"BUTUAN DOCTORS HOSP. SCHOOL OF NURSING",
				"BUTUAN DOCTORS HOSPITAL SCHOOL OF NURSING");
				
replace school="BATANGAS STATE UNIVERSITY – NASUGBU" if inlist(school, "BATANGAS STATE  UNIVERSITY-ARASOF-  NASUGBU",
				"BATANGAS STATE UNIVERSITY- ARASOF-NASUGBU",
				"BATANGAS STATE UNIVERSITY-ARASOF- NASUGBU",
				"BATANGAS STATE UNIVERSITY-ARASOF-NASUGBU");
				
replace school="BATANGAS STATE UNIVERSITY – BATANGAS CITY" if inlist(school, "BATANGAS STATE UN1VERSITY-BATANGAS CITY",
				"BATANGAS STATE UNIVERSITY- BATANGAS CITY",
				"BATANGAS STATE UNIVERSITY- BATANGAS CITY (PBMIT)",
				"BATANGAS STATE UNIVERSITY-BATANGAS CITY",
				"BATANGAS STATE UNIVERSITY-BATANGAS CITY (PBMIT)",
				"BATANGAS STATE");

replace school="BENEDICTO COLLEGE" if inlist(school, "BENEDICTO COLLEGE, INC",
				"BENEDICTO COLLEGE, INC.",
				"BENEDICTO COLLEGE. INC,");
				
replace school="BENGUET STATE UNIVERSITY - LA TRINIDAD" if inlist(school, "BENGUET STATE  UNIVERSITY-LA  TRINIDAD",
				"BENGUET STATE UNIV.(FOR.MT. STATE AGRIC. COL.)",
				"BENGUET STATE UNIVERSITY (FORMERLY MT. STATE AGRIC. COL)",
				"BENGUET STATE UNIVERSITY (FORMERLY MT. STATE AGRIC. COL.)",
				"BENGUET STATE UNIVERSITY (FORMERLY MT. STATE. AGRIC. COL.)",
				"BENGUET STATE UNIVERSITY (MT. STATE AGRIC. COL.)",
				"BENGUET STATE UNIVERSITY-LA TRINIDAD",
				"BENGUETSTATE  UNIVERSITY-LA  TRINIDAD");

replace school="BENGUET STATE UNIVERSITY - BOKOD" if inlist(school, "BENGUET STATE UNIVERSITY (BENGUET S.A.T.) BOKOD",
				"BENGUET STATE UNIVERSITY-BOKOD");
				
replace school="BIT INTERNATIONAL COLLEGE" if inlist(school, "BOHOL INSTITUTE OF TECHNOLOGY - TAGBILARAN CITY",
				"BALITE INSTITUTE OF TECHNOLOGY",
				"BOHOL INSTITUTE OF TECHNOLOGY - TAGBILARAN CITY",
				"BOHOL INSTITUTE OF TECHNOLOGY- TAGBILARAN CITY",
				"BOHOL INSTITUTE OF TECHNOLOGY-TAGBILARAN CITY");
				
replace school="BICOL UNIVERSITY - LEGAZPI CITY" if inlist(school, "BICOL UNIVERSITY - LEGASPI",
				"BICOL UNIVERSITY",
				"BICOL UNIVERSITY - LEGAZPI",
				"BICOL UNIVERSITY- LEGAZPI",
				"BICOL UNIVERSITY-LEGASPI",
				"BICOL UNIVERSITY-LEGAZPI");
				
replace school="BICOL UNIVERSITY - TABACO" if inlist(school, "BICOL UNIVERSITY - TABACO",
				"BICOL UNIVERSITY- TABACO",
				"BICOL UNIVERSITY-TABACO");
			
replace school="BICOL UNIVERSITY - POLANGUI" if inlist(school, "BICOL UNIVERSITY- POLANGUI",
				"BICOL UNIVERSITY-POLANGUI");
				
replace school="BICOL UNIVERSITY - DARAGA" if inlist(school, "BICOL UNIVERSITY-DARAGA");

replace school="BICOL UNIVERSITY - GUINOBATAN" if inlist(school,"BICOL UNIVERSITY-GUINOBATAN");

replace school="BLESSED MOTHER COLLEGE" if inlist(school, "BLESSED MOTHER COLLEGE, INC");

*BOHOL NORTHEASTERN COLLEGE IS NOW CALLED BOHOL NORTHERN STAR COLLEGES;
replace school="BOHOL NORTHERN STAR COLLEGES" if inlist(school, "BOHOL NORTHEASTERN COLLEGE");

*ASSUMED BRENT HOSPITAL SCHOOL OF MIDWIFERY IS PART OF BRENT HOSPITAL & COLLEGES, INC. - ZAMBOANGA CITY;
replace school="BRENT HOSPITAL & COLLEGES, INC. - ZAMBOANGA CITY" if inlist(school,"BRENT HOSPITAL & COLLEGES, INC.- ZAMBOANGA CITY",
				"BRENT HOSPITAL & COLLEGES, INC.-ZAMBOANGA CITY",
				"BRENT HOSPITAL, INC. - ZAMBOANGA CITY",
				"BRENT HOSPITAL, INC.- ZAMBOANGA CITY",
				"BRENT HOSPITAL, INC.-ZAMBOANGA CITY",
				"BRENT HOSPITAL SCHOOL OF MIDWIFERY");
				
*BROKENSHIRE MEMORIAL COLLEGE IS JUST BROKENSHIRE COLLEGE;
*BROKENSHIRE HAS COLLEGE OF MEDICINE AND NURSING PROGRAMS, SO ASSUMED SCHOOL OF NURSING IS PART OF BROKENSHIRE COLLEGE;				
replace school="BROKENSHIRE COLLEGE" if inlist(school, "BROKENSHIRE MEMORIAL COLLEGE",
				"BROKENSHIRE SCHOOL OF NURSING");

replace school="BALIUAG UNIVERSITY (FOR. BALIUAG COLLEGES)" if inlist(school, "BALIUAG UNIVERISTY (BALIUAG COLLEGES)",
				"BALIUAG UNIVERSITY (BALIUAG COLLEGES)",
				"BALIUAG COLLEGE");
				
*BULACAN PUBLIC COMMUNITY COLLEGE IS NOW CALLED BULACAN POLYTECHNIC COLLEGE;
*I ASSUMED BULACAN PUBLIC COLLEGE AND BULACAN COMMINITY COLLEGE REFERRED TO BULACAN PUBLIC COMMUNITY COLLEGE;
replace school="BULACAN POLYTECHNIC COLLEGE" if inlist(school, "BULACAN COMMUNITY COLLEGE",	
				"BULACAN PUBLIC COLLEGE");

replace school="BULACAN STATE UNIVERSITY - MALOLOS" if inlist(school, "BULACAN STATE  UNIVERSITY  (FOR.BCAT)-MALOLOS",
				"BULACAN STATE UNIVERSITY (FOR.BCAT)-MALOLOS",
				"BU LACAN STATE  UNIVERSITY  (FOR.BCAT)-MALOLOS",
				"BULACAN STATE UNIVERSITY (BULACAN COLLEGE OF ARTS & TRADES)");
				
*BURANEN POLYTECHNIC COLLEGE IS NOW CALLED EASTERN VISAYAS STATE UNIVERSITY- BURAUEN;
replace school="EASTERN VISAYAS STATE UNIVERSITY- BURAUEN" if inlist(school, "BURAUEN POLYTECHNIC COLLEGE");
				
				
*c: Schools starting with c;
		
replace school="UNIVERSITY OF THE CORDILLERAS" if inlist(school, "BAGUIO COLLEGE FOUNDATION");

replace school="CAGAYAN STATE UNIVERSITY - GONZAGA" if inlist(school, "CAGAYAN STATE UNIVERSITY- GONZAGA");

replace school="CALAYAN EDUACTIONAL FOUNDATION, INC." if inlist(school, "CALAYAN EDUCATIONAL FOUNDATION (FOR. MED. CENTER LUCENA)",
				"CALAYAN EDUCATIONAL FOUNDATION INC.",
				"CALAYAN EDUCATIONAL FOUNDATION INC. (MEDICAL CENTER LUCENA)",
				"CALAYAN EDUCATIONAL FOUNDATION INC.(FOR MED.CENTER LUCENA)",
				"CALAYAN EDUCATIONAL FOUNDATION INC.(FOR. MED.CTR.LUCENA)",
				"CALAYAN EDUCATIONAL FOUNDATION INC.(FOR.MED.CENTER LUCENA)",
				"CALAYAN EDUCATIONAL FOUNDATION INC.(MEDICAL CENTER LUCENA)");
				
replace school="CAPITOL UNIVERSITY (FOR.CAGAYAN CAPITOL COLL.)" if inlist(school, "CAPITOL UNIVERSITY (CAGAYAN CAPITOL COLL.)");

*PAGLAUM STATE COLLEGE IS NOW CALLED CARLOS HILADO MEMORIAL STATE COLLEGE;
replace school="CARLOS HILADO MEMORIAL STATE COLLEGE" if inlist(school, "PAGLAUM STATE COLLEGE");

generate temp=regexm(school, "^CENTRAL LUZON DOCTOR.*S HOSPITAL EDUCATIONAL INSTITUTION$");
replace school="CENTRAL LUZON DOCTOR'S HOSPITAL" if temp==1;
drop temp;

generate temp=regexm(school, "^CENTRAL LUZON DOCTOR.*S HOSPITAL$");
replace school="CENTRAL LUZON DOCTOR'S HOSPITAL" if temp==1;
drop temp;
				
replace school="CENTRAL LUZON DOCTOR'S HOSPITAL" if inlist(school, "CENTRAL LUZON DOCTOR",
				"CENTRAL LUZON DOCTORS HOSPITAL");

replace school="CHRIST THE KING COLLEGE - GINGOOG CITY" if inlist(school, "CHRIST THE KING COLLEGE- GINGOOG CITY",
				"CHRIST THE KING COLLEGE-GINGOOG CITY",
				"CHRIST THE KING  COLLEGE-GINGOOG  CITY");
				
replace school="CEBU CITY MEDICAL CENTER (CC GEN HOSP)" if inlist(school, "CEBU CITY MEDICAL CENTER ICC GEN HOSP)");

*CENTRAL ILOCANDIA COLLEGE OF SCIENCE & TECHNOLOGY IS NOW CALLED CICOSAT COLLEGES;
replace school="CICOSAT COLLEGES" if inlist(school, "CENTRAL ILOCANDIA COLLEGE OF SCIENCE & TECHNOLOGY");

replace school="CENTRAL LUZON DOCTORS HOSPITAL EDUCATIONAL INSTITUTION" if inlist(school, "CENTRAL LUZON DOCTOR'S HOSPITAL");
				
replace school="CENTRAL LUZON COLLEGE OF SCIENCE & TECHNOLOGY - OLONGAPO" if inlist(school, "CENTRAL LUZON COLLEGE OF SCIENCE & TECHNOLOGY- OLONGAPO",
				"CENTRAL LUZON COLLEGE OF SCIENCE & TECHNOLOGY-OLONGAPO",
				"CENTRAL LUZON COLLEGE OF TECHNOLOGY-OLONGAPO");
				
generate temp=regexm(school, "^LAS PI.*AS COLLEGE$");
replace school="CENTRO ESCOLAR UNIVERSITY - LAS PINAS" if temp==1;
drop temp;
				
replace school="CENTRO ESCOLAR UNIVERSITY - MAKATI" if inlist(school, "CENTRO ESCOLAR UNIVERSITY- MAKATI",
				"CENTRO ESCOLAR UNIVERSITY-MAKATI");
				
replace school="CENTRO ESCOLAR UNIVERSITY - MALOLOS" if inlist(school, "CENTRO ESCOLAR UNIVERSITY- MALOLOS",
				"CENTRO ESCOLAR UNIVERSITY-MALOLOS",
				"CENTRO ESCOLAR  UNIVERSITY-  MALOLOS");
				
*ASSUMED CEU MANILA WAS PART OF THIS;
*ASSUMED ENTRY WITHOUT A CAMPUS WAS PART OF MANILA CAMPUS;				
replace school="CENTRO ESCOLAR UNIVERSITY - MANILA" if inlist(school, "CENTRO ESCOLAR UNIVERSITY- MANILA",
				"CENTRO ESCOLAR UNIVERSITY-MANILA",
				"CENTRO ESCOLAR UNIVESITY-MANILA",
				"C. E. U. - MANILA",
				"CENTRO ESCOLAR UNIVERSITY");
				
replace school="CHINESE GENERAL HOSPITAL COLLEGES" if inlist(school, "CHINESE GENERAL HOSPITAL COLLEGE",
				"CHINESE GENERAL HOSPITAL COLLEGE OF NURSING & LI8ERAL ARTS",
				"CHINESE GENERAL HOSPITAL COLLEGE OF NURSING & LIBERAL ARTS",
				"CHINESE GENERAL HOSPITAL",
				"CHINESE GENERAL HOSPITAL MEDICAL CENTER",
				"CHINESE GENERAL' HOSPITAL MEDICAL CENTER",
				"CHINESE GEN. HOSP.");

replace school="CHONG HUA HOSPITAL" if inlist(school, "CHONG JUA HOSPITAL SCHOOL OF NURSING",
				"CHONG KUA HOSPITAL");
				
replace school="CHRIST THE KING COLLEGE - GINGOOG CITY" if inlist(school, "CHRIST THE KING COLLEGE");
				
replace school="BASILAN STATE COLLEGE" if inlist(school, "BAS I LAN STATE COLLEGE");

replace school="CABANATUAN CITY COLLEGES" if inlist(school, "CABANATUAN CITY COLIEGES",
				"CABANATUAN CITY COLLEGE",
				"CABANATUAN CITY COLLEGES");

*ASSUMED ENTRY WITHOUT CAMPUS WAS PART OF CABANATUAN;
replace school="COLLEGE OF THE IMMACULATE CONCEPTION - CABANATUAN" if inlist(school, "COLLEGE OF THE IMMACULATE CONCEPTION CABANATUAN",
				"COLLEGE OF THE IMMACULATE CONCEPTION-CABANATUAN",
				"COLLEGE OF THE IMMACULATE CONCEPTION- CABANATUAN",
				"COLLEGE OF THE IMMACULATE CONCEPTION");
				
replace school="CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY - CUENCO, CC" if inlist(school, "CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY-CUENCO, CC",
				"CEBU STATE COLLEGE OF SCIENCE & TECHNOLOGY-CUENCO, CC",
				"CEBU STATE COLLEGE OF SCIENCE & TECHNOLOGY-CUENCO");
				
replace school="CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY (MAIN)" if inlist(school, "CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY (MAIN)_",
				"CEBU TECHNOLOGICAL UNIVERSITY-MAIN (FOR.CSCST)");

				
replace school="CEBU CITY GENERAL HOSPITAL" if inlist(school, "CEBU CITY GEN HOSP");
				
*CEBU DOCTORS COLLEGE IS NOW CALLED CEBU DOCTORS UNIVERSITY;
*COLLEGE OF MEDICINE IS PART OF CEBU DOCTORS UNI SO INCLUDED IT IN ONE ENTRY;
*ASSUMED CEBU DOCTORS HOSPITAL IS PART OF CEBU DOCTORS UNI;
generate temp=regexm(school, "^CEBU DOCTORS.* COLLEGE$");
replace school="CEBU DOCTORS' COLLEGE" if temp==1;
drop temp;

replace school="CEBU DOCTORS UNIVERSITY" if inlist(school, "CEBU DOCTOR'S COLLEGE",
				"CEBU DOCTORS COLLEGES",
				"CEBU DOCTORS' COLLEGE",
				"CEBU DOCTORS COLLEGE OF MEDICINE",
				"CEBU DOCTORS HOSP. SCHOOL OF NURSING",
				"CEBU DOCTORS HOSPITAL SCHOOL OF NURSING",
				"CEBU DOCTORS HOSPITAL SOHOOL OF NURSING",
				"CEBU DOCTORS HOSP",
				"CEBU_DOCTORS COLLEGES");
				
replace school="CEBU DOCTORS UNIVERSITY" if inlist(school, "CEEU DOCTORS HOSPITAL SCHOOL OP NURSING");
				
				
*CEBU NORMAL COLLEGE AND CEBU STATE COLLEGE ARE NOW CALLED CEBU NORMAL UNIVERSITY;
replace school="CEBU NORMAL UNIVERSITY" if inlist(school, "CEBU NORMAL COLLEGE",
				"CEBU NORMAL UNIVERSITY (CEBU STATE COLLEGE)",
				"CEBU NORMAL UNIVERSITY (CEBU-STATE COLLEGE)",
				"CEBU NORMAL UNIVERSITY (FOR. CEBU STATE COLLEGE)",
				"CEBU NORMAL UNIVERSITY (FORMERLY CEBU STATE COLLEGE)",
				"CEBU STATE COLLEGE");
				
*ASSUMED CEBU ST COLLEGE (CEBU MED CENTER) IS JUST CEBU ST COLLEGE WHICH IS NOW CEBU NORMAL UNI;
replace school="CEBU NORMAL UNIVERSITY" if inlist(school, "CEBU STATE COLLEGE (CEBU MED. CENTER)",
				"CEBU STATE COLLEGE (CEBU MED. CTR.)",
				"CEBU STATE COLLEGE (CEBU MEDICAL CENTER)");
				
*CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY IS NOW CALLED CEBU TECHNOLOGICAL UNIVERSITY;
*ASSUMED ENTRIES WITHOUT CAMPUS ARE PART OF MAIN CAMPUS;
*CUENCO IS NOT A CAMPUS LISTED ON UNI WEBSITE SO ASSUMED IT WAS PART OF MAIN CAMPUS;
replace school="CEBU TECHNOLOGICAL UNIVERSITY- MAIN" if inlist(school, "CEBU STATE COLLEGE OF SCIENCE AND TECH.-COL. OF ARTS AND TRA",
				"CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY",
				"CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY (MAIN)",
				"CEBU STATE COLLEGE OF SCIENCE AND TECHNOLOGY - CUENCO, CC");
				
*TUBURAN IS A CAMPUS LISTED ON THE CEBU TECH UNI WEBSITE SO JUST CHANGED THE NAME;
replace school="CEBU TECHNOLOGICAL UNIVERISTY- TUBUCAN" if inlist(school, "CEBU STATE COLLEGE OF SCIENCE & TECHNOLOGY-TUBURAN");
				
replace school="CITY COLLEGE OF URDANETA" if inlist(school, "CITY COLLEGE OF URDANETA (URDANETA COMM. COLL.)",
				"CITT COLLEGE OF URDARETA (URDENATA COMM. COLL.)",
				"CITY COLLEGE OF URDANETA (URDENATA COMM. COLL.)");	
				
*ASSUMED ENTRY WITHOUT CAMPUS WAS PART OF BACOLOD CITY-CBT (1/3/20) NO, assume wihtout campus is MAKATI!;				
replace school="COLEGIO DE SAN AGUSTIN - BACOLOD CITY" if inlist(school, "COLEGIO DE SAN AGUSTIN-BACOLOD CITY",
				"COLEGIO DE SAN AGUSTIN - BACOLOD",
				"COLEGIO SAN  AGUSTIN-BACOLOD  CITY",
				"COLEGIO SAN AGUSTIN-BACOLOD CITY",
				"COLLEGE EGIO DE SAN AGUSTIN - BACOLOD CITY");
				
replace school="COLEGIO DE SAN AGUSTIN - MAKATI" if inlist(school,
				"COLEGIO DE SAN AGUSTIN",
				"CGLEGIO DE SAN AGUSTIN",
				"COLLEGE DE SAN AGUSTIN");
				
replace school="COLEGIO DE SAN AGUSTIN - BACOLOD CITY" if inlist(school, "GOLEGIO DE SAN AGUSTIN - BACOLOD CITY");
				
				
	
replace school="COLEGIO DE SAN AGUSTIN - MAKATI" if inlist(school, "COLEGIO DE SAN AGUSTIN-MAKATI");
	
replace school="COLEGIO DE SAN JUAN DE LETRAN - INTRAMUROS" if inlist(school, "COLEGIO DE SAN JUAN DE LETRAN- INTRAMUROS",
				"COLEGIO DE SAN JUAN DE LETRAN-INTRAMUROS");
				
replace school="COLEGIO DE SAN JUAN DE LETRAN - CALAMBA" if inlist(school, "COLEGIO DE SAN JUAN DE LETRAN-CALAMBA",
				"COLEGIO DE SAN JUAN DE LETRAN- CALAMBA");
				
replace school="COLEGIO DE SAN LORENZO RUIZ DE MANILA, INC." if inlist(school, "COLEGIO DE SAN LORENZO RUIZ DE MANILA. INC.",
				"COLEGIO OE SAN LORENZO.RUIZ DE MANILA, INC.",
				"GOLEGIO DE SAN LORENZO RUIZ DE MANILA. INC.");
				
*I COMBINED ALL THE ENTRIES THAT JUST SAID COLLEGE JUST FOR CLEANLINESS;
replace school="COLLEGE, INC" if inlist(school, "COLLEGES, INC.",
				"COLLEGE");
								
				
replace school="COLLEGE OF THE IMMACULATE CONCEPCION - TARLAC" if inlist(school, "COLLEGE OF THE HOLY SPIRIT OF TARLAC",
				"COLLEGE OF THE IMMACULATE CONCEPCION-TARLAC");
				
replace school="COLEGIO DE STA. LOURDES OF LEYTE FOUNDATION, INC." if inlist(school, "COLEGIO DE STA. LOURDES OF LEYTE FOUNDATION, INC",
				"COLEGIO DE STA. LOURDES OF LEYTE FOUNDATION. INC");
				

				
replace school="COLEGIO DE SAN ANTONIO DE PADUA" if inlist(school, "COLEGIO DE SAN ANTONIO");

*FOUND THAT LA SALLE AFFILIATE COLLEGE IS COLLEGE OF ST JOHN- ROXAS;				
replace school="COLLEGE OF ST. JOHN - ROXAS CITY" if inlist(school, "COLLEGE OF ST. JOHN-ROXAS CITY",
				"COLLEGE OF ST. JOHN-ROXAS",
				"LA SALLE AFFILIATE COLLEGE");
				
replace school="COLLEGE OF TECHNOLOGICAL SCIENCES - CEBU" if inlist(school, "COLLEGE OF  TECHNOLOGICAL  SCIENCES-CEBU",
				"COLLEGE OF TECHNOLOGICAL SCIENCES-CEBU");
				
replace school="COLLEGE OF TECHNOLOGICAL SCIENCES-CEBU" if inlist(school, "COLLEGE OF TECHNOLOGICAL SCIENCES - CEBU",
				"COLLEGE OF TECHNOLOGICA L SCIENCES-CEBU");

				
*OLONGAPO AND ZAMBALES REFER TO SAME CAMPUS;				
replace school="COLUMBAN COLLEGE- ZAMBALES" if inlist(school, "COLUMBAN COLLEGE-ZAMBALES",
				"COLUMBAN COLLEGE, INC.",
				"COLUMBAN COLLEGE-OLONGAPO CITY",
				"COLUMBAN COLLEGE- OLONGAPO CITY");
				
*COLLEGE IS ON PACO ST SO REFERS TO THE SAME;				
replace school="CONCORDIA COLLEGE" if inlist(school, "CONCORDIA  COLLEGE",
				"CONCORDIA COLLEGE (PACO)",
				"LA CONCORDIA COLLEGE");
				
replace school="CORDILLERA CAREER DEVELOPMENT COLLEGE" if inlist(school, "CORDILLERA CAREER  DEVELOPMENT  COLLEGE");
				
replace school="COTABATO MEDICAL FOUNDATION COLLEGE INC." if inlist(school, "COTABATO MEDICAL FOUNDATION COLLEGE",
				"COTABATO MEDICAL  FOUNDATION  COLLEGE");
				

replace school="CAGAYAN DE ORO COLLEGE" if inlist(school, "CAGAYAN DE ORO GOLLEGE");

replace school="CALI PARAMEDICAL COLLEGE FOUNDATION" if inlist(school, "CALI PARAMEDICAL  COLLEGE  FOUNDATION");

replace school="CAMARINES SUR POLYTECHNIC COLLEGE" if inlist(school, "CAMARINES SUR POLYTE");

replace school="CAMARINES SUR POLYTECHNIC COLLEGES - NAGA" if inlist(school, "CAMARINES SUR POLYTECHNIC COLLEGES(BICAT)- NAGA",
				"CAMARINES SUR POLYTECHNIC COLLEGES(BICAT)- NAGA",
				"CAMARINES SUR POLYTECHNIC COLLEGES(BICAT)-NAGA",
				"CAMARINES SUR POLYTECHNIC COLLEGES(BLCAT)- NAGA");

replace school="CATANDUANES STATE UNIVERSITY - VIRAC" if inlist(school, "CATANDUANES STATE COLLEGES",
				"CATANDUANES STATE COLLEGES - VIRAC",
				"CATANDUANES STATE COLLEGES- VIRAC",
				"CATANDUANES STATE COLLEGES-VI RAC",
				"CATANDUANES STATE COLLEGES-VIRAC",
				"CATANDUANES STATE UNIVERSITY - VIRAC"); 
				
replace school="CATANDUANES STATE COLLEGES-MASBATE" if inlist(school, "CATANDUANE STATE COLLEGES    - MASBATE",
				"CATANDUANES STATE COLLEGE - MASBATE",
				"CATANDUANES STATE COLLEGE-MASBATE");
				
*CATHEDRAL SCHOOL OF TECHNOLOGY IS NOW CALLED ST. MARY'S ACADEMY OF CARMEN;
replace school="ST. MARY'S ACADEMY OF CARMEN" if inlist(school, "CATHEDRAL SCHOOL OF TECHNOLOGY");

				

replace school="CATANDUANES STATE COLLEGE" if inlist(school, "CATANDUANE STATE COLLEGES");

replace school="CAVITE STATE UNIVERSITY" if inlist(school, "CAVITE STATE UNIVERSITY (DON SEVERING AGR'L. COLL.)",
				"CAVITE STATE UNIVERSITY (DON SEVERINO AGR'L. COLL.)");
		
replace school="CAMARINES SUR POLYTECHNIC COLLEGE - NABUA" if inlist(school, "CAMARINES SUR POLYTECHNIC COLLEGE-NABUA");

replace school="CAMIGUIN POLYTECHNIC STATE COLLEGE" if inlist(school, "CAMIGUIN  POLYTECHNIC STATE COLLEGE");

replace school="CAPITOL MEDICAL CENTER COLLEGES" if inlist(school, "CAPITOL MEDICAL CENTER",
				"CAPITOL MEDICAL CENTER COLLEGE OF NRSNG.",
				"CAPITOL MEDICAL CENTER COLLEGES",
				"CAPITOL MEDICAL CENTER SCHOOL OF NURSING",
				"CAPITOL MEDICAL CTR",
				"CAPITOL MEDICAL SCHOOL OF NURSING");
				
*CAGAYAN CAPITOL COLLEGE IS NOW CALLED CAPITOL UNIVERSITY;
replace school="CAPITOL UNIVERSITY (FOR.CAGAYAN CAPITOL COLL.)" if inlist(school, "CAGAYAN CAPITOL COLLEGE",
				"CAGAYAN CAPLTOL COLLEGE");
				
*CAGAYAN COLLEGES TUGUEGARAO IS NOW CALLED UNIVERSITY OF CAGAYAN VALLEY;
replace school="UNIVERSITY OF CAGAYAN VALLEY (FOR. CAGAYAN COLLEGE OF TUG.)" if inlist(school, "CAGAYAN COLLEGES TUGUEGARAO");

*ASSUMED CAGAYAN VALLEY AGRICUL COLL IS PART OF CARIG CAMPUS OF CAGAYAN ST UNI-CBT (1/3/20) actually part of Lal-lo campus;
*ASSUMED CAGAYAN ST UNI- TUGUEGARAO IS PART OF CARIG CAMPUS BECAUSE CARIG CAMPUS IS IN TUGUEGARAO; 
replace school="CAGAYAN STATE UNIVERSITY- LAL-LO" if inlist(school, "CAGAYAN VALLEY AGRICULTURAL COLLEGE");
				
replace school="CAGAYAN STATE UNIVERSITY- CARIG" if inlist(school, "CAGAYAN STATE UNIVERSITY - TUGUEGARAO");
				
*CALAMBA DOCTORS COLLEGE IS NOR CALLED CDH ALLIED MEDICAL COLLEGES;
replace school="CDH ALLIED MEDICAL COLLEGES" if inlist(school, "CALAMBA DOCTORS' COLLEGE(FOR. CDH ALLIED MEDICAL COLLEGES)");

*CALAPE POLYTECHNIC COLLEGE IS NOW PART OF BOHOL ISLAND STATE UNI VERSITY;
replace school="BOHOL ISLAND STATE UNIVERSITY" if inlist(school, "CALAPE POLYTECHNIC COLLEGE");

*CAMARINES SUR POLYTECHNIC COLLEGES - NAGA IS NOW CALLED BICOL ST COLLEGE OF APPLIED SCIENCES AND TECH;
replace school="BICOL STATE COLLEGE OF APPLIED SCIENCES AND TECHNOLOGY" if inlist(school, "CAMARINES SUR POLYTECHNIC COLLEGES - NAGA");

*NABUA IS MAIN CAMPUS SO ASSUMED ENTRY WITHOUT CAMPUS WAS PART OF NABUA;
replace school="CAMARINES SUR POLYTECHNIC COLLEGE - NABUA" if inlist(school, "CAMARINES SUR  POLYTECHNIC  COLLEGE-NABUA",
				"CAMARINES SUR POLYTECHNIC COLLEGE",
				"CAMAKINES SUR POLYTECHNIC COLLEGE");
				
*ASSUMED MAMBSAO WAS A MISPELLING;
replace school="CAPIZ STATE UNIVERSITY- MAMBUSAO" if inlist(school, "CAPIZ STATE UNIVERSITY- MAMBSAO");
				
*THIS LINE ISN'T WORKING;				
generate temp=regexm(school, "^CARTHEL SCIENCE EDUC.*L FDTN.INC. (OLRA COLLEGE FOUNDATION$");
replace school="CARTHEL SCIENCE EDUCATIONAL FOUNDATION,INC. (OLRA)" if temp==1;
drop temp;

replace school="CARTHEL SCIENCE EDUCATIONAL FOUNDATION,INC. (OLRA)" if inlist(school, "CARTHEL SCIENCE EDUC'L FDTN.INC. (OLRA COLLEGE FOUNDATION)",
				"CARTHEL SCIENCE EDUCATIONAL FOUNDATION,IN C. (OLRA)",
				"CARTHEL SCIENCE EDUCATIONAL FOUNDATION,INC. (FOR.OLRA)",
				"OIRA COLLEGE",
				"OLRA COLLEGE FOUNDATION");
				
replace school="CARTHEL SCIENCE EDUCATIONAL FOUNDATION,INC. (OLRA)" if strpos(school,"CARTHEL SCIENCE");
				
*ASSUMED ENTRY WITH NO CAMPUS WAS PART OF MAIN CAMPUS;
*CATANDUANES STATE COLLEGE IS NOW CATADUANES STATE UNIVERSITY;
replace school="CATANDUANES STATE UNIVERSITY - VIRAC" if inlist(school, "CATANDUANES COLLEGE",
				"CATANDUANES STATE CO",
				"CATANDUANES STATE COLLEGE");
								
replace school="COLEGIO DE DAGUPAN" if inlist(school, "COLEGIO DE DAGUPAN (COMPUTRONIX COLL)",
				"COLEGIO DE DAGUPAN (FOR. COMPUTRON IX COLL)",
				"COLEGIO DE DAGUPAN (FOR.COMPUTRONIX COLL)");
				
replace school="COLEGIO DE KIDAPAWAN" if inlist(school,
				"COLEGIO DE KIDAPAWAN(FOR N.COTABATO IT)",
				"COLEGIO DE KIDAPAWAN(N.COT ABATO I.T.)",
				"COLEGIO DE KIDAPAWAN(N.COTAB ATO I.T.)",
				"COLEGIO DE KIDAPAWAN(N.COTABAT O I.T.)",
				"COLEGIO DE KIDAPAWAN(N.COTABATO I.T.)",
				"COLEGIO DE KIDAPAWAN (N.COTABATO IT.)",
				"NORTH COTABATO INSTITUTE OF TECHNOLOGY");
				
*INCLUDED SCHOOL OF NURSING IN GENERAL ENTRY;				
replace school="CEBU CITY MEDICAL CENTER (CC GEN HOSP)" if inlist(school, "CEBU CITY GENERAL HOSPITAL",
				"CEBU CITY MEDICAL CENTER SCHOOL OF NURSING - CSCST");
				
replace school="CENTRAL PHILIPPINE ADVENTIST COLLEGE" if inlist(school, "CENTRAL PHILIPPINE ADVEHTIST COLLEGE");

replace school="CENTRAL PHILIPPINE UNIVERSITY" if inlist(school, "CENTRAL PHILIPPINES UNIVERSITY",
				"CENTRAL PHILIPPINE UNIVIRSITY",
				"CENTRAL-PHILIPPINE UNIVERSITY");
				
				
replace school="CAGAYAN STATE UNIVERSITY - GONZAGA" if inlist(school, "CAGAYAN STATE UNIVERSITY-GONZAGA");


replace school="NEGROS STATE COLLEGE OF AGRICULTURE" if strpos(school, "NEGROS STATE COLLEGE OF AGRICULTURE");

*THE AGRICUL COLLEGE OF CAVITE ST UNI IS NOW CALLED College of Agriculture, Forestry, Environment and Natural Resources (CAFENR);
*I INCLUDED THE ENTRIES THAT SPECIFY AGRICUL COLL AS PART OF GENERAL CAVITE ST UNI ENTRY;
*THIS LINE ISN'T WORKING;
generate temp=regexm(school, "^CAVITE STATE UNIVERSITY (DON SEVERINO AGR.*L. COLL.)$");
replace school="CAVITE STATE UNIVERSITY" if temp==1;
drop temp;
replace school="CAVITE STATE UNIVERSITY" if strpos(school, "CAVITE STATE UNIVERSITY");
			
replace school="CDH ALLIED MEDICAL COLLEGES" if inlist(school, "CDH ALLIED MEDICAL COLLEGES (CALAMBA DOCTORS)",
				"CDH ALLIED MEDICAL COLLEGES (FOR.CALAMBA DOCTORS)");

*CEBU COLLEGE OF COMMERICE IS NOW UNIVESITY OF CEBU;
replace school = "UNIVERSITY OF CEBU" if inlist(school, "CEBU CENTRAL COLLEGE",
				"CEBU CENTRAL COLLEGES",
				"UNIVERSITY OF CEBU (CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CEBU (FORM. CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CEBU (FORMERLY CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CEBU (FORMERLY. CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CE8U (FORMERLY CEBU CENTRAL COLLEGES)",
				"CEBU COLLEGE OF COMMERCE");
				
*d: Schools starting with d;

*DANIEL ROMUALDEZ MEMORIAL HOSPITAL SCHOOL OF NURSING THIS IS NOW CALLED EASTERN VISAYAS REGIONAL MED CENTER;
replace school="EASTERN VISAYAS REGIONAL MEDICAL CENTER" if inlist(school, "DANIEL ROMUALDEZ MEMORIAL HOSPITAL SCHOOL OF NURSING");

*DAVAO MERCHANT MARINE ACADEMY IS NOW CALLED DMMA COLLEGE OF SOUTHERN PHILIPPINES;
replace school="DMMA COLLEGE OF SOUTHERN PHILIPPINES" if inlist(school, "DAVAO MERCHANT MARINE ACADEMY");

replace school="DE LOS SANTOS COLLEGE" if inlist(school, "DE LOS SANTOS COLLEGE (DELOS SANTOS SCHOOL OF NRSG.)",
				"DE LOS SANTOS COLLEGE (FOR DELOS SANTOS SCHOOL OF NRSG.)",
				"DE LOS SANTOS COLLEGE (FOR. DELOS SANTOS SCHOOL OF NRSG.)",
				"DE LOS SANTOS COLLEGE (FORMERLY DELOS SANTOS SCHOOL OF NRSG.)",
				"DE LOS SANTOS COLLEGE(FORMERLY DELOS SANTOS SCHOOL OF NRSG.)",
				"DE LOS SANTOS HOSPITAL SCHOOL OF NURSING");
				
replace school="DAVAO MEDICAL SCHOOL FOUNDATION" if inlist(school, "DAVAO MEDICAL  SCHOOL  FOUNDATION",
				"DAVAO MEDICAL SCHOOL FOUNDATION",
				"DAVAO MEDICALSCHOOL",
				"DAVAO MEDICAL");
				
replace school="DAVAO DOCTORS COLLEGE, INC." if inlist(school, "DAVAO DOCTOR'S COLLEGE",
				"DAVAO DOCTORS - HOSPITAL SCOOL OF NURSING",
				"DAVAO DOCTORS COLLEGE",
				"DAVAO DOCTORS COLLEGE(DAVAO DOCTORS HOSP SCHOOL OF NURSING)",
				"DAVAO DOCTORS COLLEGE, INC.",
				"DAVAO DOCTORS COLLEGE,INC.",
				"DAVAO DOCTORS HOSP.",
				"DAVAO DOCTORS HOSP. SCH. OF NURSING",
				"DAVAO DOCTORS HOSPITAL SCHOOL OF NURSING");

*MATI COMM COLL AND DAVAO ORIENTAL ST COLLEGE OF SCI AND TECH ARE NOW CALLED DAVAO ORIENTAL ST UNI;
replace school="DAVAO ORIENTAL STATE UNIVERSITY" if inlist(school, "DAVAO ORIENTAL STATE COLLEGE OF SCIENCE & TECHNOLOGY",
				"MATI COMMUNITY COLLEGE");
				
				
replace school="DR. CARLOS S. LANTING COLLEGE - QUENZON CITY" if inlist(school, "DR. CARLOS LANTING SCHOOL OF NURSING",
				"DR. CARLOS S. LANTING COLLEGE - Q. C.",
				"DR. CARLOS S. LANTING COLLEGE - Q.C.",
				"DR. CARLOS S. LANTING COLLEGE- Q. C.",
				"DR. CARLOS S. LANTING COLLEGE-Q. C.",
				"DR. CARLOS S. LANTING COLLEGE-Q.C.",
				"DR. CARLOS S. LANTING CQLLEGE-Q. C.",
				"DR. CARLOS S. LANTING SCH. OF MIDWIFERY",
				"DR. CARLOS S. LANTING SCHOOL OF MIDWIFERY");
				
replace school="DR. CARLOS S. LANTING COLLEGE - QUENZON CITY" if inlist(school, "DR. CARLOS S. LANTING COLLEGE");
			
replace school="DR. CARLOS S. LANTING COLLEGE - ALBAY" if inlist(school, "DR. CARLOS S. LANTING COLLEGE- ALBAY",
				"DR. CARLOS S. LANTING COLLEGE-ALBAY");
				
replace school="DR. DOMINGO B. TAMONDONG MEMORIAL SCHOOL OF MIDWIFERY" if inlist(school, "DR. DOMINGO B. TAMONDONG MEM. SCH. INC. SCH. OF MIDWIFERY",
				"DR. DOMINGO B. TAMONDONG MEM. SCH., INC. SCH. OF MIDWIFERY",
				"DR. DOMINGO B. TAMONDONG MEM. SCH.. INC. SCH. OF MIDWIFERY",
				"DR. DOMINGO B. TAMONDONG MEM. SCHOOL INC.",
				"DR. DOMINGO B. TAMONDONG MEN. SCH., INC. SCH. OF MIDWIFERY",
				"DR. DOMINGO B. TAMONDOONG MEM. SCH. INC. SCH. OF MIDWIFERY");

*DE LOS SANTOS COLLEGE IS NOW DE LOS SANTOS – STI COLLEGE INC.;
replace school="DE LOS SANTOS – STI COLLEGE INC." if inlist(school, "DELOS SANTOS COLLEGE",
				"DELOS SANTOS GEN HOS",
				"DELOS SANTOS GENERAL HOSPITAL SCHOOL OF NURSING",
				"DE LOS SANTOS COLLEGE",
				"DE LOS SANTOS- STI COLLEGE,INC- (DELOS SANTOS S.N.)",
				"DE LOS SANTOS- STI COLLEGE- QUEZON AVENUE",
				"DE LOS SANTOS-STI  COLLEGE-QUEZON  AVENUE",
				"DELOS SANTOS-GENERAL HOSPITAL SCHOOL OF NURSING");

replace school="DE LOS SANTOS – STI COLLEGE INC." if inlist(school, "DE LOS SANTOS-STI COLLEGE,INC-(DELOS SANTOS S.N.)",
				"DE LOS SANTOS-STI COLLEGE- QUEZON AVENUE",
				"DE LOS SANTOS-STI COLLEGE-QUEZON AVENUE");

replace school="DIPOLOG MEDICAL CENTER COLLEGE FOUNDATION, INC." if inlist(school, "DIPOLOG MED.CTR. COLLEGE FTDN. INC(DIPOLOG MED CTR SCH OF MID)",
				"DIPOLOG MEDICAL CENTER COLLEGE FOUNDATION, INC",
				"DIPOLOG MEDICAL CENTER COLLEGE FOUNDATION. INC",
				"DIPOLOG MEDICAL CENTER COLLEGE OF HEALTH SERVICES",
				"DIPOLOG MEDICAL CENTFR COLLEGE FOUNDATION, INC",
				"DIPOLOG MEDICAL CENTER SCHOOL OF MIDWIFERY");				
			
replace school="DIVINE MERCY COLLEGE FOUNDATION, INC." if inlist(school, "DIVINE MERCY COLLEGE FOUNDATION, INC",
				"DIVINE MERCY COLLEGE FOUNDATION. INC");
				
replace school="DE OCAMPO MEMORIAL COLLEGES" if inlist(school, "DE OCAMPMEMORIAL COLLEGES",
				"DE OCAMPO MEM. COLLEGE",
				"DE OCAMPO MEMORIAL COLLEGE",
				"DE OCAMPO MEMORIAL COLLEGES",
				"DE OCAMPO MEMORIAL SCHOOL");

*DIVINE WORD UNI- TACLOBAN IS NOW CALLED LICEO DEL VERBO DIVINO;
*I ASSUMED DIVINE WORD UNI WAS PART OF DIVINE WORD UNI- TACLOBAN;				
replace school="LICEO DEL VERBO DIVINO" if inlist(school, "DIVINE MERCY COLLEGE FOUNDATION. INC",
				"DIVINE WORD UNIVERSITY OF TACLOBAN",
				"DIVINE WORD UNIVERSITY TACLOBAN",
				"DIVINE WORD UNIVERSITY- TACLOBAN",
				"DIVINE WORD UNVIVERSITY OF TACLOBAN",
				"DIVINE WORD UNIVERSITY",
				"DIVINE WORD UNIVERSITY - TACLOBAN");
				
replace school="DIVINE WORD COLLEGE - TABILGARAN" if inlist(school, "DIVINE WORD COLLEGE - TAGBILARAN",
				"DIVINE WORD COLLEGE OF TAGBILARAN",
				"DIVINE WORD COLLEGE TAGBILARAN",
				"DIVINE WORD COLLEGE- TAGBILARAN",
				"DIVINE WORD COLLEGE - TABILGARAN",
				"DIVINE WORD-TAGBILAR");
				
replace school="DIVINE WORD COLLEGE - BOHOL" if inlist(school, "DIVINE WORD COLLEGE (BOHOL)",
				"DIVINE WORD COLLEGE - BOHOL");
				
replace school="DIVINE WORD COLLEGE - LEGAZPI" if inlist(school, "DIVINE WORD COLLEGE OF LEGAZPI",
				"DIVINE WORD COLLEGE - LEGAZPI", 
				"DIVINE WORD COLLEGE");

*DIVINE WORD COLLEGE IS NOW DIVINE WORD COLLEGE OF SAN JOSE;
*THIS LINE IS BEING WEIRD- COMBINES MORE THAN ONE ENTRY;
replace school="DIVINE WORD COLLEGE OF SAN JOSE" if inlist(school, "DIVINE WORD COLLEGE    - SAN JOSE",
				"DIVINE WORD COLLEGE -OCC. MINDORO");
				
replace school="DOMINICAN COLLEGE - SAN JUAN" if inlist(school, "DOMINICAN COLLEGE-MANILA",
				"DOMINICAN COLLEGE- MANILA",
				"DOMINICAN COLLEGE- SAN JUAN, MM",
				"DOMINICAN COLLEGE-SAN JUAN, MM",
				"DOMINICAN COLLEGE - MANILA",
				"DOMINICAN COLLEGE");
				
generate temp=regexm(school, "^DOCTOR.*S CLINIC AND HOSPITAL SCHOOL FOUNDATION INC.$");
replace school="DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION, INC." if temp==1;
drop temp;
				
replace school="DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION, INC." if inlist(school, "DOCTORS CLINIC & HOSPITAL SCHOOL FOUNDATION, INC.");

replace school="DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION, INC." if inlist(school, "THE DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION, INC.",
				"THE DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION. INC.");

								
*FOUND THAT ICHAMS WAS PART OF AGOO CAMPUS;								
replace school="DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY - AGOO" if inlist(school, "DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY- AGOO",
				"DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY-AGOO",
				"DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY- ICHAMS");
				
*FOUND THAT LA UNION SCHOOL OF ARTS & TRADES IS NOW PART OF DON MARIANO MARCOS MEMORIAL STATE UNI;
replace school="DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY - SAN FERNANDO" if inlist(school, "LA UNION SCHOOL OF ARTS & TRADES");
				
replace school="DMMC INSTITUTE OF HEALTH SCIENCES, INC." if inlist(school, "DMMC INSTITUTE OF HEALTH SCIENCES, INC",
				"DMMC INSTITUTE OF HEALTH SCIENCES. INC");
				
replace school="DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION, INC." if inlist(school, "DOCTORS CLINIC AND HOSPITAL",
				"DOCTORS' CLINIC AND HOSPITAL SCHOOL FOUNDATION INC.",
				"DOCTORS CLINIC AND HOSPITAL SCHOOL FOUNDATION, INC.",
				"DOCTOR�S CLINIC AND HOSPITAL SCHOOL FOUNDATION INC.");
				
replace school="DMMA COLLEGE OF SOUTHERN PHILIPPINES" if inlist(school, "DMMA COLLEGE OF SOUTHERN PHILIPPINES (FOR.DAVAO MERCHANT MA)",
				"DMMA COLLEGE OF SOUTHERN PHILIPPINES (FOR.DAVAO MERCHANT VIA)");
				
replace school="DEE HWA LIONG COLLEGE FOUNDATION" if inlist(school, "DEE HWA LIONG  COLLEGE  FOUNDATION");

*ASSUMED ARENTA UNIVERSITY IS DE LESALLE ARANETA UNIVERSITY;
replace school="DE LESALLE ARANETA UNIVERSITY" if inlist(school, "ARANETA UNIVERSITY",
				"DE LA SALLE-ARANETA UNIVERSITY, INC (GAUF)");

generate temp=regexm(school, "^DE LA SALLE UNIVERSITY- DASMARI.*AS$");
replace school="DE LA SALLE UNIVERSITY - DASMARINAS" if temp==1;
drop temp;

replace school="DE LA SALLE UNIVERSITY - DASMARINAS" if inlist(school, "DE LA SALLE UNIVERSITY CAVITE",
				"DE LA SALLE UNIVERSITY (EAC) CAVITE",
				"DE LA SALLE UNIVERSITY (EAC CAVITE)",
				"DE LA SALLE UNIVERSITY (CAVITE)",
				"DE LA SALLE UNIVERSITY-DASHARINAS HEALTH SCIENCE CAMPUS",
				"DE LA SALLE UNIVERSITY - DASMAP.INAS",
				"DE LA SALLE UNIVERSITY - DASMARINAS",
				"DE LA SALLE UNIVERSITY- DASMARINAS HEALTH SCIENCE CAMPUS",
				"DE LA SALLE UNIVERSITY-DASMARINAS");
				
replace school="DE LA SALLE UNIVERSITY - DASMARINAS" if inlist(school, "DE LA SALLE UNIVERSITY-DASMARINAS HEALTH SCIENCE CAMPUS");

*DE LAS SALLE UNI -DASMARINAS USED TO BE CALLED DE LA SALLE UNI- EMILIO AQUINALDO COLLEGE;
replace school="DE LA SALLE UNIVERSITY - DASMARINAS" if inlist(school, "E. A. C. - D.L.S.U.",
				"E. A. C. - D.L.S.U. - DASMARINAS");


*DE LA SALLE UNIVERSITY - HEALTH SCIENCES INSTITUTE IS NOW CALLED DE LESALLE HEALTH SCIENCES INSTITUTE;
replace school="DE LA SALLE HEALTH SCIENCES INSTITUTE" if inlist(school, "DE LA SALLE UNIVERSITY-HEALTH SCIENCES INSTITUTE",
				"DE LA SALLE UNIVERSITY- HEALTH SCIENCES INSTITUTE",
				"DE LA SALLE UNIVERSITY - HEALTH SCIENCES INSTITUTE");
				
*ISABELO B. CALINGASAN MEMORIAL INSTITUTE IS NOW CALLED DR FRANCISCO CALINGASAN MEMORIAL COLLEGES FOUNDATION;
replace school="DR FRANCISCO CALINGASAN MEMORIAL COLLEGES FOUNDATION" if inlist(school, "ISABEL0 B. CALINGASAN MEMORIAL INSTITUTE",
				"ISABELO B. CALLNGASAN MEMORIAL INSTITUTE",
				"ISABELO B. CALINGASAN MEMORIAL INSTITUTE",
				"I.B CALINGASAN MEMORIAL INSTITUTE",
				"I.B. CALINGASAN MEMORIAL INSTITUTE");
				
generate temp=regexm(school, "^DR. YANGA.*S FRANCISCO BALAGTAS COLLEGE$");
replace school="DR. YANGA'S COLLEGES, INC." if temp==1;
drop temp;

*ASSUMED DB. YANGA'S FRANCISCO BALAGTAS COLLEGE WAS PART OF DR. YANGA'S COLLEGES, INC.;	

generate temp=regexm(school, "^OR, YANGA.*S FRANCISCO BALAGTAS COLLEGE$");
replace school="DB. YANGA'S FRANCISCO BALAGTAS COLLEGE" if temp==1;
drop temp;
			
replace school="DR. YANGA'S COLLEGES, INC." if inlist(school, "DR. YANGA'S COLLEGES, INC",
				"DR. YANGA'S COLLEGE",
				"DR. YANGA'S FRANCISCO BALAGTAS COLLEGE",
				"DR. YANGA*S FRANCISCO BALAGTAS COLLEGE",
				"DR. YANGA�S FRANCISCO BALAGTAS COLLEGE",
				"DR, YANGALS FRANCISCO BALAGTAS COLLEGE",
				"DR.YANGA- F BALAGTAS",
				"DB. YANGA'S FRANCISCO BALAGTAS COLLEGE");

replace school="DE LA SALLE - LIPA" if inlist(school, "DE LA SALLE UNIVERSITY-LIPA");
			
replace school="DE LA SALLE UNIVERSITY" if inlist(school, "DE LA SALLE UNIVERSITY-MANILA", 
	"DE LA SALLE UNIVERSITY - MANILA", 
	"DE LA SALLE UNIVERSITY-COLLEGE OF SAINT BENILDE");

*DUMAGUETE CATHEDRAL COLLEGE IS NOW CALLED COLGEIO DE SANTA CATALINA ALEJANDRIA;
replace school="COLEGIO DE SANTA CATALINA ALEJANDRIA" if inlist(school, "DUMAGUETE CATHEDRAL COLLEGE");

*DUMANGAS POLYTECHNIC COLLEGE IS NOW PART OF ILOILO STATE OF COLLEGE OF FISHERIES;
replace school="ILOILO STATE OF COLLEGE OF FISHERIES" if inlist(school, "DUMANGAS POLYTECHNIC COLLEGE");

				
*I assumed that MARIANO MARCOS MEMORIAL COLLEGE was part of DON MARIANO MAROCS MEM;
*I also assumed that the entries without specific campuses were part of Bacnotan campus because it is the main autonomous campus;
replace school="DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY - BACNOTAN" if inlist(school, "DON MARIANO MARCOS MEMORIAL STATE UNIVERSITY- BACNOTAN",
				"MARIANO MARCOS MEMORIAL COLLEGE",
				"MARIANO HARCOS MEM");
				
*e: Schools starting with e;


*CAN-AVID NATIONAL AGRICULTURAL COLLEGE is now part of EASTERN SAMAR STATE UNIVERSITY;
*EASTERN SAMAR STATE COLLEGE IS NOW CALLED EASTERN SAMAR STATE UNIVERSITY;
*SOUTHERN SAMAR AGRICULTURE COLLEGE IS NOW CALLED EASTERN SAMAR ST UNI;
replace school="EASTERN SAMAR STATE UNIVERSITY - BORONGAN" if inlist(school, "EASTERN SAMAR STATE COLLEGE- BORONGAN",
				"EASTERN SAMAR STATE COLLEGE-BORONGAN",
				"EASTERN SAMAR STATE UNIVERSITY -BORONGAN",
				"CAN-AVID NATIONAL AGRICULTURAL COLLEGE",
				"EASTERN SAMAR STATE-COLLEGE",
				"SOUTHERN SAMAR AGRICULTURE COLLEGE");
				
replace school="EASTERN TAYABAS COLLEGE" if inlist(school, "EASTERN TAYAHAS COLLEGE");

*SOFTNET COLLEGE OF SCIENCE & TECHNOLOGY IS NOW CALLED EASTWOODS PRO COLLEGE OF SCI AND TECH;
replace school="EASTWOODS PROFESSIONAL COLLEGE OF SCI & TECH - BALANGA,BATAAN" if inlist(school, "EASTWOODS PROFESSIONAL COLLEGE OF SCI & TECH- BALANGA,BATAAN",
				"EASTWOODS PROFESSIONAL COLLEGE OF SCI & TECH-  BALANGA,BATAAN",
				"SOFTNET COLLEGE OF SCIENCE & TECHNOLOGY");
				
				
replace school="ELISA R OCHOA MEMORIAL NORTHERN MINDANAO SCHOOL OF MIDWIFERY" if inlist(school, "E R OCHOA MEMORIAL (FORMERLY NORTHERN MINDANAO SCH OF MIDWIFERY)");
				
generate temp=regexm(school, "^EMILIO AGUINALDO COLLEGE- DASMARI.*AS$");
replace school="EMILIO AGUINALDO COLLEGE - DASMARINAS" if temp==1;
drop temp;
				
replace school="EMILIO AGUINALDO COLLEGE - DASMARINAS" if inlist(school, "EMILIO AGUINALDO  COLLEGE-  DASMARINAS",
				"EMILIO AGUINALDO COLLEGE- DASMARINAS",
				"EMILIO AGUINALDO COLLEGE-DASMARINAS");
				
*FOUND THAT MARIAN COLLEGE IS NOW CALLED EMILIO AGUINALDO COLLEGE;
*MANILA IS THE MAIN CAMPUS SO ASSUMED ENTRY WITHOUT CAMPUS WAS PART OF MANILA CAMPUS;
replace school="EMILIO AGUINALDO COLLEGE - MANILA" if inlist(school, "EMILIO AGUINALDO COLLEGE- MANILA",
				"EMILIO AGUINALDO COLLEGE-MANILA",
				"EMILIO AGUINALDO CQLLEGE-MANILA",
				"EMILIO AGUINALDO COLLEGE",
				"E. AGUINALDO COLLEGE",
				"MARIAN COLLEGE");
				
replace school="EMMANUEL COMMUNITY HOSPITAL SCHOOL OF MIDWIFERY" if inlist(school, "EMMANUEL COMMUNITY HOSP. SCH.OF MIDWIFERY",
				"EMMANUEL-COMMUNITY HOSPITAL SCHOOL OF MIDWIFERY");
				
generate temp=regexm(school, "^ESCUELA DE NUESTRA SE.*ORA DE LA SALETTE$");
replace school="ESCUELA DE NUESTRA SENORA DE LA SALETTE" if temp==1;
drop temp;
				
replace school="ESCUELA DE NUESTRA SENORA DE LA SALETTE" if inlist(school, "ESCUELA DE NUESTRA DE LAS SALLETTE",
				"ESCUELA DE NUESTRA SENORA OE LA SALETTE");
				
replace school="EULOGIO (AMANG) RODRIGUEZ INSTITUTE OF SCIENCE & TECHNOLOGY" if inlist(school, "EULOGIO (AHANG) RODRIGUEZ INSTITUTE OF SCIENCE & TECHNOLOGY");

replace school="EVELAND CHRISTIAN COLLEGE" if inlist(school, "EVELAND JUNIOR COLLEGE");

*************************************************************************;
*f: Schools starting with f;

replace school="FABIE SCHOOL OF MIDWIFERY- PANABO" if inlist(school, "FABIE SCHOOL OF HIDWIFERY-PANABQ");

replace school="FLORENCIO L. VARGAS COLLEGE- ABULUG" if inlist(school, "F. L. VARGAS COLLEGE- ABULUG",
				"F. L. VARGAS COLLEGE-ABULUG",
				"F. L. VARGAS COLLEGE - ABULUG");
				
replace school="FAMILY CLINIC COLLEGE FOUNDATION" if inlist(school, "FAMILY CLINIC",
				"FAMILY COLLEGE FOUNDATION");

*CAMPUS IN QUEZON CITY IS CALLED DILIMAN CAMPUS;
replace school="FAR EASTERN UNIVERSITY - DILIMAN" if inlist(school, "FAR EASTERN UNIVERSITY EDUCATIONAL FOUNDATION-QUEZON CITY",
				"FAR EASTERN UNIVERSITY EDUCATIONAL FOUNDATION - QUEZON CITY",
				"FAR EASTERN UNIVERSITY - QUEZON CITY",
				"FEU-FERN COLLEGE-QUEZON CITY");

*ASSUMED ENTRY WITHOUT A CAMPUS IS PART OF MANILA CAMPUS;
*ASSUMED COLLEGE OF THE FAR EAST REFERS TO FAR EASTERN UNI;
replace school="FAR EASTERN UNIVERSITY - MANILA" if inlist(school, "FAR EASTERN UNIVERSITY MANILA",
				"FAR EASTERN UNIVERSITY- MANILA",
				"FAR EASTERN UNIVERSITY-MANILA",
				"FAR EASTERN UNIVERSITY",
				"COLLEGE OF THE FAR EAST",
				"F. E. U. - MANILA");

replace school="FAR EASTERN UNIVERSITY - NICANOR REYES MEDICAL FOUNDATION" if inlist(school, "FAR EASTERN UNIVERSITY-NICANOR REYES MEDICAL FOUNDATION",
				"FAR EASTERN UNIVERSITY- NICANOR REYES MEDICAL",
				"FAR EASTERN UNIVERSITY- NICANOR REYES MEDICAL FOUNDATION",
				"FAR EASTERN UNIVERSITY-NICANOR REYES MEDICAL FOUNDATIO",
				"FAR EASTERN UNIVERSITY-NICANOR REYES MEDICAL FOUNDATION");

replace school="FATHER SATURNINO URIOS UNIVERSITY (URIOS COLL)" if inlist(school, "FATHER SATURNINO URIOS UNIVERSITY FURIOS COLL)");
				
replace school="FATIMA COLLEGE OF CAMIGUIN" if inlist(school, "FATIMA COLLEGE OF CAHIGUIN");

replace school="FATIMA MED. SCIE. FOUNDATION (FORMERLY OUR LADY OF FATIMA COL)" if inlist(school, "FATIMA MED. SCIE. FOUNDATION (FORMERLY OUR LADY DF FATIMA COL)",
				"FATIMA MED. SCIE.FOUNDATION (FOR.OUR LADY OF FATIMA COL)",
				"FATIMA MED.SCIE.FOUN",
				"FATIMA MED. SCIE. FOUNDATION (FORMERLY OUR LADY OF FATIMA COL)",
				"FATIMA MED.SCIE.FOUNDATION (FOR.OUR LADY OF FATIMA COL)"
				"FATIMA MED.SCIE.FOUNDATION (FORMERLY OUR LADY OF FATIMA COL)",
				"FATIMA MEDICAL SCIENCE FOUNDATION",
				"FATIMA MED.SCIE.FOUNDATION (FORMERLY OUR LADY OF FATIMA COL)",
				"FATIMA W. SCIE. FOUNDATION (FORMERLY OUR LADY OF FATIMA COL)");

*FATIMA MED SCI FOUNDATION IS NOW CALLED OUR LADY OF FATIMA UNI;
*ASSUMED ENTRY WITHOUT CAMPUS IS PART OF QC CAMPUS;
*CBT: 1/4/20: No, old entries for Fatima med sci foundation should be Valenzuela;
replace school="OUR LADY OF FATIMA UNIVERSITY- QUEZON CITY" if inlist(school, "FATIMA MEDICAL SCIENCE FOUNDATION, INC. - QUEZON CITY",
				"FATIMA MEDICAL SCIENCE FOUNDATION, INC.-QUEZON CITY",
				"FATIMA MEDICAL SCIENCE FOUNDATION. INC.-QUEZON CITY",
				"FATIMA MEDICAL SCIENCE FOUNDATION, INC.- QUEZON CITY");
				
replace school="OUR LADY OF FATIMA UNIVERSITY- VALENZUELA CITY" if inlist(school, "FATIMA MEDICAL SCIENCE FOUNDATION, INC.- VALENZUELA",
				"FATIMA MEDICAL SCIENCE FOUNDATION, INC.-VALENZUELA",
				"FATIMA MEDICAL SCIENCE FOUNDATION. INC.- VALENZUELA",
				"FATIMA MEDICAL SCIENCE FOUNDATION. INC.-VALENZUELA",
				"FALIMA MEDICAL SCIENCE FOUNDATION. INC.-VALENZUELA",
				"FATIMA MEDICAL SCIENCE FOUNDATION. INC. - VALENZUELA",
				"FATIMA MEDICAL SCIENCE FOUNDATION. INC. - VALENZUELA",
				"FATIMA MED. SCIE. FOUNDATION (FORMERLY OUR LADY OF FATIMA COL)",
				"OUR LADY OF FATIMA");
				
replace school="FATIMA SCHOOL OF SCIENCE & TECHNOLOGY" if inlist(school, "FATIMA SCHOOL OF SCIENCE AND TECHNOLOGY");

replace school="FELIPE R. VERALLO MEMORIAL FOUNDATION" if inlist(school, "FELIPE R. VERALLO  MEMORIAL  FOUNDATION");

replace school="FILAMER CHRISTIAN UNIVERSITY" if inlist(school, "FILAMER CHRISTIAN COLLEGE",
				"FILAMER CHRISTIAN",
				"FILAMER CHRISTIAN INSTITUTE");
				
replace school="FIRST CITY PROVIDENTIAL COLLEGE (FORMERLY FRANCISCO H.C.)" if inlist(school, "FIRST CITY PROVIDENTIAL COLLEGE (FOR.FRANCISCO H.C.)", 
				"FIRST CITY  PROVIDENTIAL  COLLEGE  (FOR.FRANCISCO H.C.)",
				"FIRST CITY PROVIDENTIAL COLLEGE (FRANCISCO H.C.)");
				
replace school="FLORENCIO L. VARGAS COLLEGE - TUGUEGARAO" if inlist(school, "FLORENCIO L. VARGAS COLLEGE- TUGUEGARAO",
				"FLORENCIO L. VARGAS COLLEGE-TUGUEGARAO");

*ASSUMED ANY GENERAL FOUNDATION ENTRY IS PART OF FOUNDATION UNIVERSITY;
replace school= "FOUNDATION UNIVERSITY" if inlist(school, "FOUNDATION  UNIVERSITY",
				"FOUNDATION",
				"FOUNDATION COLLEGES");
*Fixed to Immaculate Conception College;				
replace school="IMMACULATE CONCEPTION COLLEGE" if inlist(school, "IMMACULATE CONEAPTION COLLEGE",
				"IMMACULATE-CONCEPTION COLLEGE",
				"IMMACULATE CONCEPTION COLLEGE");

*************************************************************************;
*g: Schools starting with g;

replace school="GALANG MEDICAL CENTER SCHOOL OF NURSING" if inlist(school, "GALANG MEDICAL CENTER SCHOOL OF NRSNG.",
				"GALANG MEDICAL CENTER",
				"GALANG MED CENTER");

generate temp=regexm(school, "^GENERAL SANTOS DOCTORS.* MEDICAL SCHOOL FOUNDATION$");
replace school="GENERAL SANTOS DOCTORS' MEDICAL SCHOOL FOUNDATION" if temp==1;
drop temp;
				
replace school="GENERAL SANTOS DOCTORS' MEDICAL SCHOOL FOUNDATION" if inlist(school, "GENERAL SANTOS DOCTORS' MEDICAL SCHOOL");

replace school="GENSANTOS FOUNDATION, INC." if inlist(school, "GENSANTOS FOUNDATION. INC.");

replace school="GLOBAL CITY INNOVATIVE COLLEGE" if inlist(school, "GLOBAL CITY  INNOVATIVE  COLLEGE");

replace school="GOLDEN GATE COLLEGES" if inlist(school, "GOLDEN SATE COLLEGES",
				"GOLDEN GATE COLLEGE");

replace school="GOOD SAMARITAN COLLEGE" if inlist(school, "GOOD SAMARITAN COLLEGES");
 
replace school="GORDON COLLEGE (FORMERLY OLONGAPO CITY COLL.)" if inlist(school, "GORDON COLLEGE (FOR.OLONGAPO CITY COLL.)",
				"GORDON COLLEGE (OLGNGAPO CITY COLL.)",
				"GORDON COLLEGE (OLONGAPO CITY COLL.)");
				
replace school="GREAT PLEBEIAN COLLEGE" if inlist(school, "GREAT PLEBIAN COLLEGE");
				
replace school="GUAGUA NATIONAL COLLEGE" if inlist(school,"GUAGUA NATIONAL COLLEGES");

*************************************************************************;
*h: Schools starting with h;

replace school="HOLY CROSS COLLEGE - PAMPANGA" if inlist(school, "HOLY CROSS COLLEGE-PAMPANGA", 
				"HOLY CROSS COLLEGE- PAMPANGA");

replace school="HOLY NAME UNIVERSITY (FORMERLY DIVINE WORD -TAGBILARAN)" if inlist(school, "HOLY NAME UNIVERSITY (FOR.DIVINE WORD-TAGBILARAN)",
				"HOLY NAME UNIVERSITY (DIVINE NORD-TAGBILARAN)",
				"HOLY NAME UNIVERSITY (DIVINE W0RD-TAGBILARAN)",
				"HOLY NAME UNIVERSITY (DIVINE WORD- TAGBILARAN)",
				"HOLY NAME UNIVERSITY (DIVINE WORD-TAGBILARAN)",
				"HOLY NAME UNIVERSITY (FOR.DIVINE WORD- TAGBILARAN)");
				
*HOLY NAME COLLEGE IS NOW HOLY NAME UNIVERSITY;
*DIVINE WORD COLLEGE - TABILGARAN IS NOW HOLY NAME UNIVERSITY;
*I FOUND THAT THE BOHOL AND TAGBILARAN ARE SAME CAMPUS;
replace school="HOLY NAME UNIVERSITY (FORMERLY DIVINE WORD -TAGBILARAN)" if inlist(school, "HOLY NAME COLLEGE",
				"DIVINE WORD COLLEGE - TABILGARAN",
				"DIVINE WORD COLLEGE - BOHOL");
				
*HOLY TRINITY COLLEGE IS NOW CALLED HOLY TRINITY UNIVERSITY;
*There is a holy trinity college in Gen San, but I think this is the Palawan school;
replace school="HOLY TRINITY UNIVERSITY" if inlist(school, "HOLY TRINITY COLLEGE",
				"HOLY TRINITY COLLEGE OF PUERTO PRINCESA");

*************************************************************************;
*i: Schools starting with i;

replace school="ICCT COLLEGES FOUNDATION, INC(FORMERLY INST. OF CREATIVE COMP TECH INC)" if inlist(school, "ICCT COLLEGES FOUNDATION, INC(INST. OF CREATIVE COMP TECH INC)",
				"ICCT COLLEGES FOUNDATION,IN C(INST.OF CREATIVE COMP TECH INC)",
				"ICCT COLLEGES FOUNDATION,INC(I NST.OF CREATIVE COMP TECH INC)",
				"ICCT COLLEGES FOUNDATION,INC(INS T.OF CREATIVE COMP TECH INC)",
				"ICCT COLLEGES FOUNDATION,INC(INST OF CREATIVE COMP TECH INC)",
				"ICCT COLLEGES FOUNDATION,INC(INST.OF CREATIVE COMP TECH INC)");
				
replace school="IFUGAO STATE UNIVERSITY (FOR. IFUGAO SCAF)-LAMUT" if inlist(school, "IFUGAO STATE COLLEGE OF AGRICULTURE & FORESTRY-LAMUT");

replace school="ILIGAN MEDICAL CENTER COLLEGE, INC." if inlist(school, "ILIGAN MEDICAL CENTER COLLEGE. INC.",
				"ILIGAN MEDICAL CENTER COLLEGE",
				"ILIGAN MEDICAL CENTER",
				"ILIGAN MEDICAL CENT.",
				"ILIGAN MEDICAL-CENTER COLLEGE");
				
generate temp=regexm(school, "^ILOILO DOCTORS.* COLLEGE$");
replace school="ILOILO DOCTORS COLLEGE" if temp==1;
drop temp;

*SCHOOL OF MIDWIFERY IS PART OF THE COLLEGE SO COMBINED INTO SAME ENTRY;
*COLLEGE OF MEDICINE IS PART OF THE COLLEGE SO COMBINED INTO SAME ENTRY;
replace school="ILOILO DOCTORS COLLEGE" if inlist(school, "ILOILO DOCTOR'S COLLEGE",
				"ILOILO DOCTORS COLLEGE  SCHOOL OF MIDWIFERY",
				"ILOILO DOCTORS COLLEGE OF MEDICINE");
				
replace school="ILOILO DOCTORS COLLEGE" if inlist(school, "ILOILO DOCTORS' COLLEGE SCHOOL OF MIDWIFERY");
				
replace school="ILOILO SCHOOL OF ARTS AND TRADES" if inlist(school, "ILOILO SCHOOL OF ARTS & TRADES");

replace school="ILOILO SCHOOL OF ARTS AND TRADES" if inlist(school, "ILOILO SCHOOLOF ARTS AND TRADES");

*ILOILO SCHOOL OF ARTS AND TRADES IS NOW CALLED ILOILO SCIENCE AND TECH UNI;
replace school="ILOILO SCIENCE AND TECHNOLOGY UNIVERSITY" if inlist(school, "ILOILO SCHOOL OF ARTS AND TRADES");

			
replace school="IMMACULATE CONCEPCION HOSPITAL SCHOOL OF NURSING" if inlist(school, "IMACULATE CONCEPTION HOSPITAL SCHOOL OF NURSING",
				"IMMA CONCEPCION HOSP");

replace school="IMMACULATE CONCEPCION COLLEGE - ALBAY" if inlist(school, "IMMACULATE  CONCEPTION  COLLEGE-ALBAY",
				"IMMACULATE CONCEPTION COLLEGE (ALBAY)",
				"IMMACULATE CONCEPTION COLLEGE - ALBAY",
				"IMMACULATE CONCEPTION COLLEGE- ALBAY",
				"IMMACULATE CONCEPTION COLLEGE-ALBAY");


replace school="IMMACULATE CONCEPCION HOSPITAL SCHOOL OF NURSING" if inlist(school, "IMMACULATE CONCEPCION HOSP.SCH. OF NURSING",
				"IMMACULATE CONCEPCION HOSPITAL SPHOOL OF NURSING",
				"IMMACULATE- CONCEPCION HOSPITAL SCHOOL OF NURSING");
				
*IMMACULATE CONCEPTION COLLEGE-LA SALLE IS NOW CALLED LA SALLE UNIVERSITY;
*ASSUMED IMMACULATE CONCEPTION OZAMIS CITY IS PART OF LA SALLE UNI BECAUSE LA SALLE UNI IS IN OZAMIS;
replace school="LA SALLE UNIVERSITY (FOR.IMMA.CONCEPCION-LA SALLE)" if inlist(school, "IMMACULATE CONCEPTION COLLEGE-LA SALLE",
				"IMMACULATE CONCEPCION COLLEGE - OZAMIS CITY");		

*IMMACULATE CONCEPTION COLLEGE IS NOW CALLED UNI OF THE IMMACULATE CONCEPTION;
*THE UNI IS IN DAVAO SO I ASSUMED ONLY THE IMM CONC COLLEGE DAVAO ENRIES REFERRED TO THE UNIVERISTY;				
replace school="UNIVERSITY OF THE IMMACULATE CONCEPTION- DAVAO" if inlist(school, "IMMACULATE CONCEPTION COLLEGE-DAVAO",
				"IMMACULATE CONCEPTION COLLEGE - DAVAO");

replace school="ISABELA COLLEGES (FORMERLY ISABELA C.F)" if inlist(school, "ISABELA COLLEGES (FOR.ISABELA C.F)",
				"ISABELA COLLEGES (ISABELA C.F)",
				"ISABELA COLLEGES (FORMERLY ISABELA C.F)");

*COLLEGE OF AGRICUL IS PART OF UNI SO I COMBINED INTO SAME ENTRY;
*FOUND THAT AGRICUL COLLEGE IS IN ECHAGUE;				
replace school="ISABELA STATE UNIVERSITY - ECHAGUE" if inlist(school, "ISABELA STATE UNIVERSITY-ECHAGUE",
				"ISABELA STATE UNIVERSITY- ECHAGUE",
				"ISABELA STATE UNIVERSITY-ECHAGUE",
				"ISABELA STATE  UNIVERSITY-  ECHAGUE",
				"ISABELA STATE COLLEGE OF AGRICULTURE");
				
replace school="ISABELA STATE UNIVERSITY - ILAGAN" if inlist(school, "ISABELA STATE UNIVERSITY-ILAGAN",
				"ISABELA STATE UNIVERSITY-I LAGAN",
				"ISABELA STATE UNIVERSITY- ILAGAN");
				
*FOUND THAT THE ISABELA ST UNI POLYTECHNIC COLLEGE IS PART OF CAUAYAN CAMPUS;
replace school="ISABELA STATE UNIVERSITY- CAUAYAN" if inlist(school, "ISABELA STATE UNIVERSITY - POLYTECHNIC COLLEGE");
		

*************************************************************************;
*j: Schools starting with j;
replace school="J.P. SIOSON COLLEGES, INC." if inlist(school, "J. P. SIOSON MEDICAL CENTER - SCHOOL OF MIDWIFERY",
				"J. P. SIOSON COLLEGES. INC.(FOR J.P.SIOSON MED.CTR.-MIDWIFERY)",
				"J. P. SIOSON COLLEGES, INC.(FOR.J.P.SIOSON MED.CTR.-MIDWFRY)",
				"J. P. SIOSON COLLEGES, INC.",
				"J. P. SIOSON",
				"J.P. SIOSON COLLEGES, INC.(FOR J.P. SIOSON MED.CTR.-MIDWFRY)");
				
replace school="JAMIATU MARAWI AL - ISLAMIA FOUNDATION" if inlist(school, "JAMIATU MARAWI AL-ISLAMIA FOUNDATION",
				"JAMIATU MARAWI AL- ISLAMIA FOUNDATION",
				"JAMIATU MARAWI AL-ISLAHIA FOUNDATION",
				"JAMIATU MARAWI-ISLAMIA FOUNDATION",
				"JAMIATUL PHILIPPINE AL-ISLAMIA");

*JOHN B. LACSON COLLEGES FOUNDATION-BACOLOD CITY IS NOW CALLED JOHN B LACSON FOUNDATION MARITIME UNI;
replace school="JOHN B LACSON FOUNDATION MARITIME UNIVERSITY-BACOLOD CITY" if inlist(school, "JOHN B. LACSON COLLEGES FOUNDATION (IMA-BACOLOD)",		
				"JOHN B. LACSON COLLEGES FOUNDATION-BACOLOD CITY");
				
replace school="JOHN B LACSON FOUNDATION MARITIME UNIVERSITY-ILOILO" if inlist(school,
				"J.B. LACSON COLLEGE FOUNDATION (IMA-ILOILO)");

replace school="JOSE C. FELICIANO COLLEGE FOUNDATION, INC (FOR. JCF SST)" if inlist(school, "JOSE C. FELICIANO COLLEGE  FOUNDATION, INC (FOR. JCF SST)",
				"JOSE C. FELICIANO SCHOOL OF SCIENCE & TECHNOLOGY");
				
replace school="JOSE RIZAL MEMORIAL STATE UNIVERSITY - DAPITAN" if inlist(school, "JOSE RIZAL MEMORIAL STATE UNIVERSITY-DAPITAN",
				"JOSE RIZAL MEMORIAL STATE UNIVERSITY- DAPITAN",
				"JOSE RIZAL MEMORIAL STATE COLLEGE-DAPITAN");
				
replace school="JOSE RIZAL UNIVERSITY (FOR.JRC)" if inlist(school, "JOSE RIZAL UNIVERSITY (JRC)");

replace school="JOSEFINA H. CERILLES STATE COLLEGE-MAIN-MATI(JHCPC)" if inlist(school, "JOSEFINA H. CERILLES STATE COLLEGE-MAIN- MATI(JHCPC)",
				"JOSEFINA H. CERILLES POLYTECHNIC COLLEGE");
			
*J.P. SIOSON COLLEGES, INC. IS NOW CALLED JP SIOSON GENERAL HOSPITAL AND COLLEGES;
replace school="JP SIOSON GENERAL HOSPITAL AND COLLEGES" if inlist(school, "J.P. SIOSON COLLEGES, INC.");

*FOUND THAT KALINGA APAYAO STATE COL IS NOW CALLED KALINGA STATE UNIVERSITY;
replace school="KALINGA STATE UNIVERSITY" if inlist(school, "KALINGA APAYAO STATE COL.(FORMERLY KALINGA COMMUNITY COLLEGE");			

replace school="BAGUIO COLLEGE FOUNDATION" if inlist(school, "BAGUIO COLLEGES FOUNDATION");

replace school="BAGUIO GENERAL HOSPITAL AND MEDICAL CENTER" if inlist(school, "BAGUIO CENERAL HOSPITAL",
				"BAGUIO GENERAL HOSPITAL",
				"EFRAIN C. MONTEMAYOR MEDICAL CENTER");
		
replace school="UNIVERSITY OF THE CORDILLERAS" if inlist(school, "BAGUIO COLLEGE FOUNDATION");

replace school="BUTUAN CITY COLLEGES" if inlist(school, "8UTUAN CITY COLLEGES");

replace school="LYCEUM OF THE PHILIPPINES-LAGUNA" if inlist(school, "(FOR.LYCEUM INST.OF TECH)",
				"LYCEUM INSTITUTE OF TECHNOLOGY");

replace school="ANDRES BONIFACIO COLLEGE" if inlist(school, "ANDRES BONIFACIO MEMORIAL SCHOOL OF MIDWIFERY");

replace school="MARY JOHNSTON COLLEGE" if inlist(school, "ARY JOHNSTON COLLEGE");

replace school="MARY JOHNSTON COLLEGE" if inlist(school, "ARY JOHNSTON COLLEGE");

*************************************************************************;
*L-Z: Schools starting with L-Z;

replace school="LA CAROLOTA CITY COLLEGE" if inlist(school, "LA CARLOTA CITY COMMUNNITY COLLEGE");

replace school="LA CONSOLACION COLLEGE - DAET" if inlist(school, "LA CONSOLACION COLLEGE-DAET");

replace school="LA CONSOLACION COLLEGE- MANILA" if inlist(school, "LA CONSOLACION COLLEGE - MANILA",
				"LA CONSOLACION COLLEGE-MANILA");
				
replace school="LA CONSOLACION COLLEGE- PASIG" if inlist(school, "LA CONSOLACION COLLEGE-PASIG");

replace school="LA CONSOLACION COLLEGE- CARLOTA CITY" if inlist(school, "LA CONSOLACION COLLEGE-LA GARLOTA CITY");

replace school="LACSON COLLEGE" if inlist(school, "LACSON COLEGE");

replace school="LA CONSOLACION COLLEGE- CALOOCAN" if inlist(school, "LA CONSOLACION COLLEGE- CALOOKAN",
				"LA CONSOLACION COLLEGE-CALOOCAN",
				"LA CONSOLACION COLLEGE-CALOOKAN");
				
*REGINA CARMELI COLLEGE IS NOW CALLEDLA CONSOLACION UNIVERSITY;
replace school="LA CONSOLACION UNIVERSITY" if inlist(school, "LA CONSOLACION  UNIVERSITY  PHILIPPINES(FOR.  U.REGINA CARMELI)",
				"LA CONSOLACION UNIVERSITY PHILIPPINES(FOR. U.REGINA CARMELI)",
				"REGINA CARMELI COLLEGE");
				
*LA UNION COLLEGE OF NURSING, ARTS & SCIENCES IS NOW CALLED LA FINN'S SCHOLASTICA;
replace school="LA FINN'S SCHOLASTICA (FOR LUCNAS)" if inlist(school, "LA UNION COLLEGE OF NURSING, ARTS & SCIENCES",
				"LA UNION COLLEGE OF NURSING. ARTS & SCIENCES");
				
replace school="LAGUNA COLLEGE" if inlist(school, "LAGUNA COLLEGE OF BUSINESS & ARTS");
				
replace school="LAGUNA NORTHWESTERN COLLEGE" if inlist(school, "LAGUNA NORTHWESTER N COLLEGE",
				"LAGUNA NORTHWESTERN INSTITUTE",
				"LAGUNA  NORTHWESTERN  COLLEGE");
				
*THE OTHER LAGUNA ST POLYTECHNIC CAMPUSES HAVE FEW OBSERVATIONS BUT ARE LEGIT CAMPUSES;
replace school="LAGUNA STATE POLYTECHNIC COLLEGE- SANTA CRUZ" if inlist(school, "LAGUNA STATE POLYTECHNIC COLLEGE-STA. CRUZ (LCAT)",
				"LAGUNA STATE POLYTECHNIC UNIV-STA CRUZ (LSPC)");
				
*I THINK THIS IS DE LESALLE UNIVERSITY, BUT CAN'T FIND A MATCH WITH ITS FORMER NAME;				
replace school="LA SALLE UNIVERSITY (FOR.IMMA.CONCEPCION-LA SALLE)" if inlist(school, "LA SALLE UNIVERSITY (FOR.IMMA.CONCEPCIO N-LA SALLE)",
				"LA SALLE UNIVERSITY (IMM.CONC. COLL- LA SALLE)",
				"LA SALLE UNIVERSITY (IMM.CONC. COLL-LA SALLE)");
				
*FOUND THAT LA SALLE SCHOOL IS NOW LA SALLE COLLEGE ANTIPOLO;
replace school="LA SALLE COLLEGE ANTIPOLO" if inlist(school, "LA SALLE SCHQOL-ANTIPOLO");

replace school="LAS PINAS GENERAL HOSPITAL" if inlist(school, "LAS PINAS GEN HOSP");
				
*LAS PINAS COLLEGE IS NOW CALLED CENTRO ESCOLAR LAS PINAS;
*SATELLITE CAMPUS OF CENTRO ESCOLAR UNIVERSITY;
replace school= "CENTRO ESCOLAR LAS PINAS" if inlist(school, "LAS PINAS COLLEGE",
				"DR. FAUSTINO LEGASPI UY COLLEGE",
				"DR. FAUST IRO LEGASPI UY COLLEGE",
				"DR. F LEGASPI UY COLLEGE",
				"DR. FAUSTINO L. UY COLLEGE");

generate temp=regexm(school, "LAS PI.*AS COLLEGE$");
replace school="CENTRO ESCOLAR LAS PINAS" if temp==1;
drop temp;
				
*ASSUMED LICEO DE ORO COLLEGE WAS PART OF LICEO DE CAGAYAN UNI;
replace school="LICEO DE CAGAYAN UNIVERSITY" if inlist(school, "LI CEO DE CAGAYAN UNIVERSITY",
				"LICEO DE CAGAYAN",
				"LICEO OE CAGAYAN UNIVERSITY",
				"LICIO DE CAGAYAN",
				"LICEO DE ORO COLLEGE");
				
replace school="LPU-ST. CABRINI COLLEGE OF ALLIED MEDICINE, INC.(LYCEUM- ST C" if inlist(school, "LPU-ST. CABRINI COLLEGE OF ALLIED MEDICINE, INC. (LYCEUM-ST C",
				"LPU-ST. CABRINI COLLEGE OF ALLIED MEDICINE, INC.(LYCEUM-ST C");
								
			
replace school="LUNA GOOD MEDICAL CENTER & COLLEGES" if inlist(school, "LUNA GOOD MEDICAL CENTER & COLLEGES",
				"LUKA-G0C0 MEDICAL CENTER & COLLEGES",
				"LUKA-GOCO MEDICAL CENTER & COLLEGES"); 

*FEW OBSERVATIONS BUT I FOUND IT ON THE INTERNET;
replace school="LYCEUM OF SUBIC BAY" if inlist(school, "LYCEUM SUBIC BAY, INC.",
				"LYCEUM SUBIC BAY, NC.");
				
*DUQUE COLLEGE IS LYCEUM NORTHWERSTEN UNIVERSITY MEDICAL COLLEGE;
*COULDNT FIND MUCH ON URDANETA CAMPUS EXCEPT FOR IN UNIVERSITY HISTORY PAGE;
replace school="LYCEUM NORTHWESTERN UNIVERSITY- URDANETA" if inlist(school, "LYCEUM NORTHWESTERN- FLORENCIA T. DUQUE COLLEGE",
				"LYCEUM NORTHWESTERN-F.T. DUQUE COLLEGE- URDANETA",
				"LYCEUM NORTHWESTERN-F.T. DUQUE COLLEGE-URDANETA",
				"LYCEUM NORTHWESTER N-FLORENCIA T. DUQUE COLLEGE",
				"LYCEUM  NORTHWESTERN-F.T. DUQUE COLLEGE-URDANETA");

*ASSUMED DAGUPAN SCHOOL OF NURSING IS LYCEUM NW UNI BECUASE LYCEUM NW STARTED OFF AS DAGUPAN CITY SCHOOL OF NURSING;				
replace school="LYCEUM NORTHWESTERN UNIV- DAGUPAN CITY" if inlist(school, "LYCEUM NORTHWESTERN",
				"LYCEUM NORTHWESTERN COLLEGE",
				"LYCEUM NORTHWESTERN INSTITUTE",
				"LYCEUM NORTHWESTERN UNIV-DAGUPAN CITY",
				"LYCEUM NORTHWESTERN- DAGUPAN CITY",
				"LYCEUM  NORTHWESTERN-DAGUPAN CITY",
				"DAGUPAN SCHOOL OF NURSING");
				
				
replace school="LYCEUM-ST. CABRINI COLLEGE OF ALLIED MEDICINE, INC." if inlist(school, "LYCEUM-ST. CABRINI COLLEGE OF ALLIED MEDICINE. INC.");

*THIS IS A ROUND ABOUT LINE OF CODE-IGNORE;
replace school="LYCEUM-ST. CABRINI COLLEGE OF ALLIED MEDICINE, INC." if inlist(school, "LPU-ST. CABRINI COLLEGE OF ALLIED MEDICINE, INC.(LYCEUM- ST C");

replace school="LYCEUM OF THE PHILIPPINES UNIVERSITY- LAGUNA" if inlist(school, "LYCEUM OF THE PHILIPPINES- LAGUNA (FOR.LYCEUM INST.OF TECH)",
				"LYCEUM OF THE PHILIPPINES-LAGUNA",
				"LYCEUM OF THE PHILIPPINES-LAGUNA (FOR.LYCEUM INST.OF TECH)");

*MANILA DOCTORS COLLEGE NOW CALLED MANILA TYTANA COLLEGES;
replace school="MANILA TYTANA COLLEGES" if inlist(school, "MANILA DOCTORS COLLEGE",
				"MANILA DOCTOR'S COLLEGE",
				"MANILA DOCTOR'S COLLEGE OF NURSING",
				"MANILA DOCTORS",
				"MANILA DOCTORS COLLEGE",
				"MANILA DOCTORS'  COLLEGE INC.",
				"MANILA DOCTORS' COLLEGE",
				"MANILA DOCTORS' COLLEGE INC.",
				"MANILA DOCTORS' COLLEGE OF NURSING");
				
replace school="MANILA TYTANA COLLEGES" if inlist(school, "MANILA TYTANA COLLEGES, INC (FOR. MANILA DOCTORS COLL)");

replace school="MARIANO MARCOS STATE UNIVERSITY- BATAC" if inlist(school, "MARIANO MARCOS STATE UNIVERSITY");

replace school="MARIANO MARCOS STATE UNIVERSITY - LAOAG CITY" if inlist(school, "MARIANO MARCOS STATE UNIVERSITY-LAOAG-COLL. OF EDUCATION");

*SAINT BERNADETTE COLLEGE OF HEALTH AND SCIENCES IS NOW CALLED MARIE-BERNARDE COLLEGE;
replace school="MARIE-BERNARDE COLLEGE, INC (FOR.ST BERNADETTE C.H.S)" if inlist(school, "MARIE-BERNARDE COLLEGE, INC (FOR.BERNADETTE CHS)",
				"SAINT BERNADETTE COLLEGE OF HEALTH AND SCIENCES");

*MARIKINA SCHOOL OF ARTS AND TRADE IS NOW CALLED MARIKINA POLYTECHNIC COLLEGE;
*FEW OBSERVATIONS BUT I FOUND INFO ON THE INTERNET;
replace school="MARIKINA POLYTECHNIC COLLEGE" if inlist(school, "MARIKINA SCHOOL OF ARTS & TRADES",
				"MARIKINA SCHOOL OF ARTS AND TRADES");
				
*MARINDUQUE INSTITUTE OF SCIENCE AND TECHNOLOGY IS NOW CALLED MARINDUQUE STATE COLLEGE;
replace school="MARINDUQUE STATE COLLEGE- BOAC" if inlist(school, "MARINDUQUE-INSTITUTE OF SCIENCE AND TECHNOLOGY");

replace school="MASBATE COLLEGE" if inlist(school, "MASBATE COLLEGES",
				"MAS8ATE COLLEGE");				
				
replace school="MATER DEI COLLEGE- BOHOL" if inlist(school, "MATER DEI COLLEGE-BOHOL");

replace school="NAGA COLLEGE FOUNDATION" if inlist(school, "NASA COLLEGE FOUNDATION");

*FEW OBSERVATIONS BUT SEEMS LEGIT;
*THERE ARE 2 CAMPUSES IN QUEZON CITY- CUBAO AND FAIRVIEW, ASSUMED ENTRY THAT SAID QUEZON CITY WAS CUBAO CAMPUS;
replace school="NATIONAL COLLEGE OF BUSINESS & ARTS-CUBAO" if inlist(school, "NATIONAL COLLEGE OF BUSINESS & ARTS - QUEZON CITY");

replace school="NATIONAL COLLEGE OF BUSINESS & ARTS- RIZAL" if inlist(school, "NATIONAL COLLEGE OF BUSINESS & ARTS-RIZAL");



replace school="NATIONAL UNIVERSITY- BAGUIO CITY" if inlist(school, "NATIONAL UNIVERSITY-BAGUIO CITY"); 

replace school="NATIONAL UNIVERSITY- MANILA" if inlist(school, "NATIONAL UNIVERSITY",
				"NATIONAL UNIVERSITY-MANILA"); 
				
replace school="NAVAL STATE UNIVERSITY (FOR.NAVAL INST)- NAVAL" if inlist(school, "NAVAL STATE UNIVERSITY (FOR.NAVAL INST)-NAVAL",
				"NAVAL INSTITUTE OF TECHNOLOGY-NAVAL", "NAVAL STATE UNIVERSITY (FOR.NAVAL INST) BILIRAN");
				
replace school="NAZARENUS COLLEGE FOUNDATION" if inlist(school, "NAZARENUS  COLLEGE  FOUNDATION",
				"NAZARENUS COLLEGE");
				
*CBT split to Nazareth school of nursing;
replace school="NAZARENUS SCHOOL OF NURSING" if inlist(school, 
				"NAZARETH SCH OF NRSG",
				"NAZARETH SCHOOL OF NURSING");
				
replace school="NORZAGARAY COLLEGE" if inlist(school, "NORZAGARAY  COLLEGE");

generate temp=regexm(school, "^LANAO ISLAMIC PARAMEDICAL COLLEGE .*MARAWI CITY$");
replace school="LANAO ISLAMIC PARAMEDICAL COLLEGE -MARAWI CITY" if temp==1;
drop temp;
				
replace school="LIPA CITY COLLEGES" if inlist(school, "LI PA CITY COLLEGE",
				"LIPA CITY COLLEGE",
				"LIPA CITY PUBLIC COLLEGE",
				"LIPA CITYCOLLEGE");
				
replace school="LUNA GOOD MEDICAL CENTER & COLLEGES" if inlist(school, "LUNA GOCO COLLEGES, INC (FOR.LUNA GOCO MCCI)",
				"LUNA GOCO MEDICAL CENTER & COLLEGES".
				"LUNA GOCO MEDICAL CENTER I COLLEGES",
				"LUNA-GOCO MEDICAL CENTER & COLLEGES",
				"LUNA-GOCO MEDICAL CENTER S COLLEGES",
				"LUNAGOCO COLLEGES, INC (FOR.LUNA GOCO MCCI)",
				"LUNA GOCO MEDICAL CENTER I COLLEGES");
				
replace school="LYCEUM NORTHERN LUZON" if inlist(school, "LYCEUM OF NORTHERN LUZON");

*I assumed entry without location was part of the original campus, whcih is Dagupan City;
replace school="LYCEUM NORTHWESTERN UNIV- DAGUPAN CITY" if inlist(school, "LYCEUM NORTHWESTER N");
				
replace school="LYCEUM OF APARRI" if inlist(school, "LYCEUM OFAPARRI");
	
*ASSUMED LYCEUM MERCHANT MARINE ACADEMY WAS PART OF LYCEUM OF THE PHIL UNI;	
replace school="LYCEUM OF THE PHILIPPINES UNIVERSITY-BATANGAS,INC" if inlist(school, "LYCEUM OF THE PHILIPPINES UNIVERSITY- BATANGAS,INC",
				"LYCEUM OF THE PHILIPPINES UNIVERSITY-BATANGAS.INC",
				"LYCEUM MERCHANT MARINE ACADEMY",
				"LYCEUM OF BATANGAS");
				
replace school="LYCEUM OF THE PHILIPPINES UNIVERSITY- MANILA" if inlist(school, "LYCEUM OF THE  PHILIPPINES  UNIVERSITY-MANILA",
				"LYCEUM OF THE",
				"LYCEUM OF THE PHILIPPINES",
				"LYCEUM OF THE PHILIPPINES- MANILA",
				"LYCEUM OF THE PHILIPPINES-MANILA",
				"LYCEUM OF THE PHILIPPINES UNIVERSITY-MANILA");
				
replace school="MAKATI MEDICAL CENTER COLLEGE" if inlist(school, "MAKATI MEDICAL CENTER",
				"MAKATI MEDICAL CENTER (FOR. RTRMS)");

replace school="MAPANDI MEMORIAL COLLEGE" if inlist(school, "MAPANDI MEMORIAL",
				"MAPANDI EDUCATIONAL INSTITUTE",
				"MAPANDI MEMORIAL COLLEGE SCHOOL OF MIDWIFERY");
				
*Mapua Institute of Technology now called Mapua University;
				
replace school="MAPUA UNIVERSITY- MANILA" if inlist(school, "MAPUA INSTITUTE OF TECHNOLOGY",
				"MAPUA INSTITUTE OF TECHNOLOGY-MANILA");

replace school="MAPUA UNIVERSITY- MAKATI" if inlist(school, "MAPUA INSTITUTE OF  TECHNOLOGY-  MAKATI",
				"MAPUA INSTITUTE OF TECHNOLOGY- MAKATI",
				"MAPUA INSTITUTE OF TECHNOLOGY-MAKATI");
			
replace school="LYCEUM OF THE PHILIPPINES-LAGUNA" if inlist(school, "(FOR.LYCEUM INST.OF TECH)");

replace school="MANILA ADVENTIST COLLEGE" if inlist(school, "MANILA ADVENTIST COLLEGE(FOR MLA ADV. MCSMA)",
				"MANILA ADVENTIST MEDICAL CENTER & SCH. OF MEDICAL ARTS, INC");

replace school="MANILA CENTRAL UNIVERSITY- CALOOCAN CITY" if inlist(school, "MANILA CENTRAL UNIVERSITY",
				"MANILA CENTRAL UNIVERSITY - CALOOCAN",
				"MANILA CENTRAL UNIVERSITY - CALOOCAN CITY",
				"MANILA CENTRAL UNIVERSITY-CALOOCAN CITY");
				
replace school="MANILA CENTRAL UNIVERSITY- MANILA" if inlist(school, "MANILA CENTRAL UNIVERSITY - MANILA",
				"MANILA CENTRAL UNIVERSITY-MANILA");
				
generate temp=regexm(school, "^MANILA DOCTORS.* COLLEGE$");
replace school= "MANILA DOCTORS COLLEGE" if temp==1;
drop temp;

generate temp=regexm(school, "^MANILA DOCTORS.* COLLEGE OF NURSING$");
replace school= "MANILA DOCTORS COLLEGE" if temp==1;
drop temp;

*MANILA DOCTORS COLLEGE IS NOW MANILA TYTANA COLLEGES;
*The College of Nursing in MANILA TYTANA COLLEGES is called MANILA DOCTORS COLLEGE OF NURSING, but I combined it with MANILA TYTANA COLLEGES entry;
replace school="MANILA TYTANA COLLEGES" if inlist(school, "MANILA DOCTORS COLLEGE");
				
replace school="MANUEL V. GALLEGO FOUNDATION COLLEGE" if inlist(school, "MANUEL V. GALLEGO FOUNDATION");
				
replace school="MANUEL S. ENVERGA UNIVERSITY FOUNDATION- CANDELARIA" if inlist(school, "MANUEL S. ENVERGA UNIVERSITY FOUNDATION-CANDELARIA",
				"MANUEL S.ENVERGA UNIVERSITY FOUNDATION-CANDELARIA");
				
replace school="MANUEL S. ENVERGA UNIVERSITY FOUNDATION- LUCENA CITY" if inlist(school, "MANUEL S. ENVERGA UNIVERSITY FOUNDATION-LUCENA CITY",
				"MANUEL S. ENVERGA UNIVERSITY FQUNDATION-LUCENA CITY",
				"MANUEL S.ENVERGA UNIVERSITY FOUNDATION-LUCENA CITY",
				"MANUEL S. ENVERGA UNIVERSITY FOUNDATION");
				
replace school="MANUEL L. QUEZON UNIVERSITY" if inlist(school, "MANUEL QUEZON COLLEGE");
				
replace school="MARIANO MARCOS STATE UNIVERSITY- BATAC" if inlist(school, "MARIANO MARCOS STATE UNIVERSITY-BATAC",
				"MARIANO MARCOS STATE UNIVERSITY - BATAC",
				"MARIANO MARCOS STATE UMIVERSITY-BATAC",
				"MARIANO MARCOS STATE UHIVERSITY-6ATAC");
				
replace school="MARINDUQUE STATE COLLEGE- BOAC" if inlist(school, "MARINDUQUE STATE COLLEGE-BOAC");

replace school="MARTINEZ MEMORIAL COLLEGE" if inlist(school, "MARTINEZ MEM. COLLEGE");

replace school="MARY CHILES COLLEGE (FOR.GEN. HOSP. SCH. OF NRSNG. & MID.)" if inlist(school, "MARY CHILES",
				"MARY CHILES COLLEGE",
				"MARY CHILES COLLEGE (GEN. HOSP. SCH. GF NRSNG. & MID.)",
				"MARY CHILES COLLEGE (GEN. HOSP. SCH. OF NRSNG. MID.)",
				"MARY CHILES COLLEGE (GEN. HOSP. SCH. OF NRSNG. & MID.)",
				"MARY CHILES GEN. HOSP. SCH. OF NRSNG & MIDWIFERY",
				"MARY CHILES GENERAL HOSPITAL SCH. OF NURSING & MIDWIFERY",
				"MARY CHILES GENERAL HOSPITAL SCH. OF NURSING I MIDWIFERY",
				"MARY CHILES GENERAL HOSPITAL SCH. OF NURSING MIDWIFERY");
				
replace school="MARY CHILES COLLEGE (FOR.GEN. HOSP. SCH. OF NRSNG. & MID.)" if inlist(school, "MARY CHILES HOSPITAL",
				"MARY CHILES SCHOOL OF NURSING",
				"MARY CHILES-GENERAL HOSPITAL SCH. OF NURSING & MIDWIFERY");
				
replace school="MOUNT CARMEL COLLEGE- BULACAN" if inlist(school, "MOUNT CARMEL COKEGE-BULACAN",
				"MOUNT CARMEL COLLEGE-BULACAN");
				
replace school="MARY JOHNSTON COLLEGE" if inlist(school, "ARY JOHNSTON COLLEGE");

replace school="MARY JOHNSTON COLLEGE" if inlist(school, "ARY JOHNSTON COLLEGE");

replace school="MABINI COLLEGE- DAET" if inlist(school, "MABINI COLLEGE DAET",
				"MABINI COLLEGE-DAET");
				
replace school="MABINI COLLEGE- DAET" if inlist(school, "MABINI COLLEGE");

*I combined MCU-Caloocan City and MCU-Manila entries because there appears to only be one campus in Caloocan City, Manila;
replace school="MANILA CENTRAL UNIVERSITY- CALOOCAN CITY" if inlist(school, "M. C. U. - CALOOCAN",
				"M. C. U. - MANILA",
				"MANILA CENTRAL UNIVERSITY- MANILA");
				
replace school="MARIANO MARCOS STATE UNIVERSITY- BATAC CITY" if inlist(school, "M. M. S. U. - BATAC",
				"MARIANO MARCOS STATE UNIVERSITY- BATAC");

replace school="MARIANO MARCOS STATE UNIVERSITY- LAOAG CITY" if inlist(school, "M. MARCOS STATE UNIV.- LAOAG CITY",
				"M. MARCOS STATE UNIV.-LAOAG CITY",
				"MARIANO MARCOS STATE UNIVERSITY - LAOAG CITY");

replace school="MEDICAL COLLEGE OF NORTHERN PHILIPPINES" if inlist(school, "MEDICAL COLLEGE OF  NORTHERN  PHILIPPINES");

*ASSUMED ENTRY WITHOUT CAMPUS IS PART OF OZAMIS CITY WHICH IS THE MAIN CAMPUS;
replace school="MEDINA COLLEGE- OZAMIZ CITY" if inlist(school, "MEDINA COLLEGE");

replace school="MEDINA COLLEGE- IPIL" if inlist(school, "MEDINA COLLEGE-IPIL");

replace school="MEDICAL CENTER LUCENA" if inlist(school, "MED CENTER- LUCENA");

replace school="MEDINA COLLEGE- OZAMIZ CITY" if inlist(school, "MEDINA COLLEGE- OZAMIS CITY",
				"MEDINA COLLEGE-OZAMIS CITY",
				"MEDINA COLLEGE-OZAMLS CITY",
				"MEDINA CQLLEGE-OZAMIS CITY");
				
*ST. JOHN GENERAL HOSPITAL AND COLLEGE IS NOW CALLED MEDINA COLLEGE- PAGADIAN;
replace school="MEDINA COLLEGE - PAGADIAN (ST.JOHN GEN. HOSP. & COLL.)" if inlist(school, "MEDINA COLLEGE - PAGAD1AN (ST.JOHN GEN. H0SP.& COLL.)",
				"MEDINA COLLEGE - PAGAD1AN (ST.JOHN GEN. HOSP.& COLL.)",
				"MEDINA COLLEGE - PAGADIAN (ST.JOHN GEN. HOSP.& COLL.)",
				"MEDINA COLLEGE- PAGADIAN (FOR.ST.JOHN GEN. HOSP.& COLL.)",
				"MEDINA COLLEGE- PAGADIAN (ST.JOHN GEN. HOSP.& COLL.)",
				"MEDINA COLLEGE-PAGADIAN (FOR.ST.JOHN GEN. HOSP.& COLL.)",
				"MEDINA COLLEGE-PAGADIAN (ST.JOHN GEN. HOSP.& COLL.)");

*CBT: 1/4/20: Buug should not be under Padigan;
replace school="MEDINA COLLEGE - PAGADIAN (ST.JOHN GEN. HOSP. & COLL.)" if inlist(school, "ST. JOHN GENERAL HOSPITAL AND COLLEGE",
				"ST. JOHN GENERAL HOSPITAL COLLEGE");
				
replace school="MEDINA COLLEGE - BUUG (ST.JOHN GEN. HOSP. & COLL.)" if inlist(school,
				"SAINT JOHN GENERAL HOSPITAL COLLEGE- BUUG",
				"SAINT JOHN GENERAL HOSPITAL COLLEGE-BUUG");
				
				
replace school="MEIN COLLEGE INC.- ZAMBOANGA CITY" if inlist(school, "MEIN COLLEGE INC.-ZAMBOANGA CITY");

replace school="METROPOLITAN MEDICAL CENTER OF COLLEGE OF ARTS, SCIE & TECH" if inlist(school, "METROPOLITAN HOSPITAL COLLEGE OF NURSING",
				"METROPOLITAN HOSPITAL SCHOOL OF",
				"METROPOLITAN HOSPITAL SCHOOL OF NURSING",
				"METROPOLITAN COLLEGE OF SCIENCE & TECHONOLOGY",
				"METROPOLITAN HOSP",
				"METROPOLITAN HOSPITAL");
				
replace school="MICRO ASIA COLLEGE OF SCIENCE AND TECHNOLOGY" if inlist(school, "MICRO ASIA COLLEGE OF SIENCE & TECHNOLOGY");
				
*I ASSUMED ORO INSTITUTE OF TECHNOLOGY WAS PART OF MINA DE ORO INSTITUTE;				
replace school="MINA DE ORO INSTITUTE OF SCIENCE & TECHNOLOGY" if inlist(school, "HINA DE ORO INSTITUTE OF SCIENCE & TECHNOLOGY",
				"ORO INSTITUTE OF TECHNOLOGY");
			
replace school="MINDANAO INSTITUTE OF HEALTHCARE PROFESSIONALS,INC" if inlist(school, "MINDANAO INSTITUTE OF  HEALTHCARE  PROFESSIONALS,INC",
				"MINDANAO INSTITUTE OF HEALTHCARE PROFESSIONALS,INC");

*LOCATED IN DAVAO CITY;
replace school="MINDANAO MEDICAL FOUNDATION COLLEGE" if inlist(school, "MINDANAO MEDICAL  FOUNDATION  COLLEGE",
				"MINDANAO MEDICAL FOUNDATION",
				"MINDANAO-DAVAO CITY",
				"MLNDANAO MEDICAL FOUNDATION");
				
*MINDANAO SANITARIUM & HOSPITAL COLLEGE OF MEDICAL ARTS FNDTN IS NOW CALLED ADVENTIST MEDICAL CENTER COLLEGE;
*MINDANAO WAS CUT OFF IN THE ORIGINAL PDF CONVERSION;
*Not double counted because "SANITARIUM & HOSPITAL COLLEGE OF MEDICAL ARTS FNDTN" was missing in all years;
replace school="ADVENTIST MEDICAL CENTER COLLEGE- ILLIGAN INC" if inlist(school, "MINDANAO SANITARIUM & HOSPITAL COLLEGE OF MED. ARTS FOUND.",
				"MINDANAO SANITARIUM & HOSPITAL COLLEGE OF MEDICAL ARTS FNDTN",
				"SANITARIUM & HOSPITAL COLLEGE OF MEDICAL ARTS FNDTN",
				"MINDANAO");

replace school="MINDANAO STATE UNIVERSITY- BUUG" if inlist(school, "MINDANAO STATE UNIVERSITY - BUUG",
				"MINDANAO STATE UNIVERSITY-BUUG");
				
replace school="MINDANAO STATE UNIVERSITY - JOLO" if inlist(school, "MINDANAO STATE UNIVERSITY- SDTC-JOLO",
				"MINDANAO STATE UNIVERSITY-SDTC-JOLO");

replace school="MINDANAO STATE UNIVERSITY- MARAWI CITY" if inlist(school, "MINDANAO STATE UNIVERSITY - MARAWI CITY",
				"MINDANAO STATE UNIVERSITY - MARAWL CITY",
				"MINDANAO STATE UNIVERSITY-MARAWI CITY",
				"MINDANAO STATE  UNIVERSITY-MARAWI  CITY",
				"MINDANAO STATE UNIVERSITY");
				
replace school="MINDANAO STATE UNIVERSITY- ILIGAN INSTITUTE OF TECHNOLOGY" if inlist(school, "MINDANAO STATE UNIVERSITY-ILIGAN INSTITUTE OF TECHNOLOGY");

replace school="MIRIAM COLLEGE (MARYKNOLL COLLEGE FOUNDATION, INC)" if inlist(school, "MARYKNOLL COLLEGE FOUNDATION");

replace school="MISAMIS ORIENTAL INSTITUTE OF SCIENCE & TECHNOLOGY" if inlist(school, "MISAMIS ORIENTAL STATE COLLEGE OF AGRICULTURE & TECHNOLOGY");

replace school="MISAMIS UNIVERSITY- OROQUIETA CITY" if inlist(school, "MISAMIS UNIVERSITY - OROQUIETA UNIT",
				"MISAMIS UNIVERSITY-OROQUIETA UNIT");

*ASSUMED ENTRIES WITHOUT SPECIFIC CAMPUS WERE PART OF OZAMIS CITY CAMPUS;
replace school="MISAMIS UNIVERSITY- OZAMIS CITY" if inlist(school, "MISAMIS UNIVERSITY - OZAMIS CITY",
				"MISAMIS UNIVERSITY-OZAMIS CITY",
				"MISANIS UNIVERSITY",
				"MISAMIS UNIVERSITY");

replace school="MOUNTAIN VIEW COLLEGE" if inlist(school, "MT. VIEW COLLEGE");

replace school="M. V. GALLEGO FOUNDATION COLLEGES" if inlist(school, "M. V-. GALLEGO FOUNDATION COLLEGES",
				"M. V. GALLEGO",
				"M. V. GALLEGO  FOUNDATION  COLLEGES",
				"M.V. GALLEGO FOUNDATION COLLEGES");
				
replace school="NATIONAL UNIVERSITY- BAGUIO CITY" if inlist(school, "NATIONAL  UNIVERSITY-BAGUIO  CITY");

replace school="NATIONAL UNIVERSITY- MANILA" if inlist(school, "NATIONAL  UNIVERSITY-MANILA");

				
replace school= "NEGROS ORIENTAL STATE UNIVERSITY (CVPC)-DUMAGUETE" if inlist(school, "NEGROS ORIENTAL STATE UNIVERSITY (CVPC)- DUMAGUETE");

*CENTRAL MINDANAO TECHNICAL INSTITUTE IS NOW CALLED NORTH CENTRAL MINDANAO COLLEGES;
replace school="NORTH CENTRAL MINDANAO COLLEGES (CMTI)" if inlist(school, "CENTRAL MINDANAO TECHNICAL INSTITUTE");
				
replace school="NORTH DAVAO COLLEGES-PANABO" if inlist(school, "NORTH DAVAO COLLEES-PANABO",
				"NORTH DAVAO COLLEGE",
				"NORTH DAVAO COLLEGE FDTN. INC.",
				"NORIH DAVAO COLLEGE");
				
replace school="NORTH DAVAO COLLEGE-TAGUM FOUNDATION" if inlist(school, "NORTH DAVAO  COLLEGE-TAGUM  FOUNDATION",
				"NORTH DAVAO COLLEGE FOUNDATION - TAGUM, DAVAO",
				"NORTH DAVAO COLLEGE-TAGUN FOUNDATION",
				"NORTH COTABATO - TAGUM FOUNDATION");
				
replace school="NORTHEASTERN COLLEGE" if inlist(school, "NORTHEASTERN  COLLEGE");

replace school="NORTHERN CHRISTIAN COLLEGE" if inlist(school, "NORTHERN CHRISTIAN C",
				"NORTHERN/CHRISTIAN COLLEGE");

replace school="NORTHERN COTABATO COLLEGES FOUNDATION INC. (FOR.COTA T.INS)" if inlist(school, "NORTHERN COTABATO COLLEGES FOUNDATION INC. (FOR.COTA. T.INS)");

*THE ADDRESS IS IN ESTANCIA SO COMBINED THE TWO ENTRIES;
replace school="NORTHERN ILOILO POLYTECHNIC STATE COLLEGE" if inlist(school, "NORTHERN ILOILO POLYTECHNIC STATE COLLEGE-ESTANCIA");

*NORTHERN MINDANAO STATE INSTITUTE OF SCIENCE & TECHNOLOGY IS NOW CALLED CARAGA STATE UNI;
replace school="CARAGA STATE UNIVERSITY" if inlist(school, "NORTHERN MINDANAO STATE INSTITUTE OF SCIENCE & TECHNOLOGY");

replace school="NORTHERN NEGROS STATE COLLEGE OF SCIENCE & TECHNOLOGY" if inlist(school, "NORTHERN NEGROS STATE COLLEGE OF SCIENCE I TECHNOLOGY",
				"NORTHERN NEGROS STATE COLLEGE OF");
				
replace school="NORTHERN SAMAR COLLEGES" if inlist(school, "NORTHERN SAMAR ACADEMY");

replace school="NORTH VALLEY COLLEGE FOUNDATION, INC." if inlist(school, "NORTH VALLEY COLLEGE FOUNDATION INC.",
				"NORTH VALLEY COLLEGE FOUNDATION, INC",
				"NORTH VALLEY COLLEGE FOUNDATION. INC.");
				
*CANDON COMMUNITY COLLEGE IS NOW CALLED NORTHERN LUZON PHILIPPINES STATE COLLEGE;
*ASSUMED NORTHERN LUZON STATE COLLEGE REFERS TO NORTHERN LUZON PHILIPPINES STATE COLLEGE;
replace school="NORTHERN LUZON PHILIPPINES STATE COLLEGE" if inlist(school, "NORTHERN LUZON STATE COLLEGE",
				"CANDON COMMUNITY COLLEGE");
				
replace school="NORTHWESTERN UNIVERSITY" if inlist(school, "NORTHWESTERN  UNIVERSITY",
				"NORTHWESTER N UNIVERSITY",
				"NORTHWESTERN COLLEGE",
				"NORTHWESTERN-COLLEGE");
				
*NOTRE DAME OF DADIANGAS COLLEGE is now called NOTRE DAME OF DADIANGAS UNIVERSITY;
replace school="NOTRE DAME OF DADIANGAS UNIVERSITY" if inlist(school, "NOTRE DAME OF DADIAN6AS COLLEGE",
				"NOTRE DAME OF DADIANGAS",
				"NOTRE DAME OF DADIANGAS COLLEGE",
				"NOTRE DAME OF DADIANGAS UNIVERSITY, INC",
				"NOTRE DAME OF DADLANGAS COLLEGE",
				"NOTRE DAME-DADIANGAS",
				"NOTRE GAME OF DADIANGAS COLLEGE");
				
replace school="NOTRE DAME OF KIDAPAWAN COLLEGE" if inlist(school, "NOTRE DAME OF KIDAPAWAN",
				"NOTRE DAME KIDAPAWAN COLLEGE");
				
replace school="NOTRE DAME OF MIDSAYAP COLLEGE" if inlist(school, "NOTRE DAME- OF MIDSAYAP COLLEGE");
				
replace school="NOTRE DAME UNIVERSITY" if inlist(school, "NOTRE DAHE UNIVERSITY");

replace school="NOTRE DAME OF MARBEL UNIVERSITY" if inlist(school, "NOTRE DAME OF MARBEL COLLEGE");

replace school="NOVA COLLEGE, INC" if inlist(school, "NOVA COMPUTER COLLEGE");
				
generate temp=regexm(school, "^NUEVA ECIJA DOCTOR.*S HOSPITAL$");
replace school="NUEVA ECIJA DOCTOR'S HOSPITAL" if temp==1;
drop temp;
				
replace school="NUEVA ECIJA COLLEGES" if inlist(school, "NUEVA ECIJA COLLEGE",
				"NUEVA ECIJA",
				"NUEVA ECJJA DOCTOR'S HOSPITAL");
				
*FOUND THAT NUEVA VIZCAYA STATE INSTITUTE OF TECH - BAYOMBONG IS NOW NUEVA VIZCAYA ST UNI;
replace school="NUEVA VIZCAYA STATE UNIVERSITY" if inlist(school, "NUEVA VIZCAYA STATE INSTITUTE OF TECH - BAYOMBONG",
				"NUEVA VIZCAYA STATE INSTITUTE OF TECHNOLOGY");
				
		
				
*CENTRAL LUZON POLYTECHNIC COLLEGE IS NOW CALLED NUEVA EXIJA UNI OF SCI AND TECH;
*ASSUMED ENTRY WITHOUT CAMPUS IS PART OF MAIN CAMPUS ENTRY;				
replace school="NUEVA ECIJA UNIVERSITY OF SCIENCE & TECH (CLPC-CABANATUAN)" if inlist(school, "NUEVA ECIJA UNIVERSITY OF SCIENCE & TECHNOLOGY- CABANATUAN)",
				"NUEVA ECIJA UNIVERSITY OF SCIENCE & TECHNOLOGY-CABANATUAN)",
				"CENTRAL LUZON POLYTECHNIC COLLEGE");
				
replace school="OLIVAREZ COLLEGE" if inlist(school, "OLIVARES COLLEGE"); 

replace school="OLIVAREZ COLLEGE- PARANAQUE" if inlist(school, "OLIVAREZ COLLEGE",
				"OLIVAREZ COLLEGE-PARANAQUE");

generate temp=regexm(school, "^OLIVAREZ COLLEGE- PARA.*AQUE$");
replace school="OLIVAREZ COLLEGE- PARANAQUE" if temp==1;
drop temp;

generate temp=regexm(school, "^OLIVAREZ COLLEGE-PARA.*AQUE$");
replace school="OLIVAREZ COLLEGE- PARANAQUE" if temp==1;
drop temp;

replace school="OLIVAREZ COLLEGE- TAGAYTAY CITY" if inlist(school, "OLIVAREZ COLLEGE-TAGAYTAY CITY");

generate temp=regexm(school, "^ORTA.*EZ UNIVERSITY$");
replace school="ORTANEZ UNIVERSITY" if temp==1;
drop temp;

*NUEVA ECIJA DOCTORS COLLEGE was aquired by OUR LADY OF FATIMA UNIVERSITY so now it is considered a campus of OUR LADY UNI;
replace school="OUR LADY OF FATIMA UNIVERSITY- NUEVA ECIJA DOCTORS COLLEGES" if inlist(school, "NUEVA ECIJA COLLEGES",
				"NUEVA ECIJA DOCTOR'S");
				
replace school="OUR LADY OF FATIMA UNIVERSITY- VALENZUELA CITY" if inlist(school, "OUR LADY OF FATIMA"
				"OUR LADY OF FATIMA  UNIVERSITY-  VALENZUELA",
				"OUR LADY OF FATIMA COLLEGE",
				"OUR LADY OF FATIMA COLLEGE - VALENZUELA",
				"OUR LADY OF FATIMA UNIVERSITY- VALENZUELA",
				"OUR LADY OF FATIMA UNIVERSITY-VALENZUELA",
				"OUR LADY OF FATIMA  UNIVERSITY-  VALENZUELA");
				
replace school="OUR LADY OF FATIMA UNIVERSITY- QUEZON CITY" if inlist(school, "OUR LADY OF FATIMA COLLEGE - QC",
				"OUR LADY OF FATIMA COLLEGE-QC",
				"OUR LADY OF FATIMA UNIVERSITY-QC"); 
				
replace school="OUR LADY OF FATIMA UNIVERSITY- ANTIPOLO CITY" if inlist(school, "OUR LADY OF FATIMA UNIVERSITY-ANTIPOLO CITY");

replace school="OUR LADY OF GUADALUPE COLLEGES" if inlist(school, "OUR LADY OF  GUADALUPE  COLLEGES");
				
replace school="OUR LADY OF LOURDES COLLEGE FOUNDATION" if inlist(school, "OUR LADY OF LOURDES COLEGE",
				"OUR LADY OF LOURDES COLLEGE",
				"OUR LADY OF LOURDES COLLEGE FOUND.",
				"OUR LADY OF LOURDES SCH. OF MIDWIFERY",
				"OUR LADY OF LOURDES SCH.OF MIDWIFERY",
				"OUR LADY OF LOURDES SCHOOL OF MIDWIFERY");
				
replace school="OUR LADY OF MERCY COLLEGE - BORONGAN" if inlist(school, "OUR LADY OF MERCY C0LLEGE-B0R0NGAN",
				"OUR LADY OF MERCY COLLEGE- BORONGAN",
				"OUR LADY OF MERCY COLLEGE-BORONGAN",
				"OUR LADY OF MERCY COLLEGE FOUNDATION");
				
replace school="OUR LADY OF REMEDIES ACADEMY COLLEGE FDTN SCHOOL OF MIDWIFERY" if inlist(school, "O. L. OF REMEDIES ACAD. COLLEGE FDTN SCH OF MIDWIFERY",
				"OUR LADY REMEDIES ACADEMY COLLEGE FDTN SCHOOL OF MIDWIFERY");
				
generate temp=regexm(school, "^OUR LADY OF THE PILLAR.*S COLLEGE$");
replace school="OUR LADY OF THE PILLAR'S COLLEGE" if temp==1;
drop temp;

*It seems as though there are not multiple campuses;
replace school="OUR LADY OF THE PILLAR'S COLLEGE" if inlist(school, "OUR LADY OF THE PILLAR'S COLLEGE-SN FERMIN, CAUAYAN",
				"OUR LADY OF THE PILLAR COLLEGE-CAUAYAN SAN MIGUEL BRANCH");
				
*PANAY STATE POLYTECHNIC UNIVERSITY IS NOW CAPIZ STATE UNIVERSITY;
replace school="CAPIZ STATE UNIVERSITY- MAMBSAO" if inlist(school, "CAPIZ STATE UNIVERSITY (PANAY SPC)-MAMBUSAG",
				"PANAY STATE POLYTECHNIC COLLEGE-MABUSAO");
				
replace school="CAPIZ STATE UNIVERSITY- ROXAS CITY" if inlist(school, "CAPIZ STATE UNIVERSITY (CIT) (PSPC)-MAIN CAMPUS",
				"CAPIZ STATE UNIVERSITY (CIT)(PSPC)-MAIN CAMPUS",
				"PANAY STATE POLYTECHNIC COLLEGE");
				
replace school="CAPIZ STATE UNIVERSITY - PONTEVEDRA CAMPUS" if inlist(school, "PANAY STATE POLYTECHNIC COLLEGE- PONTEVEDRA",
				"PANAY STATE POLYTECHNIC COLLEGE-PONTEVEDRA");

*PAGADIAN COLLEGE OF CRIMINOLOGY & SCIENCES IS NOW CALLED PAGADIAN CAPITOL COLLEGE;
replace school="PAGADIAN CAPITOL COLLEGE" if inlist(school, "PAGADIAN COLLEGE OF CRIMINOLOGY & SCIENCES");

replace school="PAMANTASAN NG CABUYAO" if inlist(school, "PAHANTASAN NG CABUYAO");

replace school="PAMANTASAN NG LUNGSOD NG PASAY" if inlist(school, "PAHANTASAN NG LUNGSOD NG PASAY");

replace school="PAMANTASAN NG LUNGSOD NG PASIG" if inlist(school, "PAHANTASAN NG LUNGSOD NG PASIG");

*I ASSUMED PALAWAN TEACHER'S COLLEGE WAS PART OF PSU BECAUSE IT HAS A COLLEGE OF COLLEGE OF TEACHER EDUCATION;
replace school="PALAWAN STATE UNIVERSITY-P. PRINCESA" if inlist(school, "PALAWAN STATE  UNIVERSITY-P.  PRINCESA",
				"PALAWAN TEACHER'S COLLEGE");
				
replace school="PANGASINAN COLLEGE OF SCIENCE AND TECHNOLOGY" if inlist(school, "PANGASINAN COLLEGE OF SCIENCE & TECHNOLOGY");
				
replace school="PANGASINAN STATE UNIVERSITY- BAYAMBANG" if inlist(school, "PANGASINAN STATE  UNIVERSITY-  BAYAMBANG",
				"PANGASINAN STATE UNIVERSITY-BAY AM BANG",
				"PANGASINAN STATE UNIVERSITY-BAYAMBANG");
				
replace school="PANGASINAN STATE UNIVERSITY- URDANETA" if inlist(school, "PANGASINAN STATE UNIVERSITY - URDANETA, PANG.",
				"PANGASINAN STATE UNIVERSITY-URDANETA");

*FOUND THAT PANGASINAN COLLEGE OF SCIENCE AND TECHNOLOGY IS NOW PART OF PUNP;
replace school="PANPACIFIC UNIVERSITY NORTH PHILIPPINES (PANG.CST)" if inlist(school, "PANFACIFIC UNIVERSITY NORTH PHILIPPINES (PANG.CST)",
				"PANGASINAN COLLEGE OF SCIENCE AND TECHNOLOGY");
				
*I ASSUMED PANGASINAN MARITIME INSTITUTE WAS THE SAME AS PANGASINAN MERCHANT MARINE ACADEMY;
replace school="PANGASINAN MERCHANT MARINE ACADEMY" if inlist(school, "PANGASINAN MARITIME INSTITUTE");

replace school="PATTS COLLEGE OF AERONAUTICS" if inlist(school, "PATTS SCHOOL OF AERONAUTICS");
				
*PERPETUAL HELP COLLEGE PART OF UNIVERSITY OF PERPETUAL HELP SYSTEM;				
replace school="PERPETUAL HELP COLLEGE - MANILA" if inlist(school, "PERP HELP COL-MANILA",
				"PERPETUAL HELP COLLEGE MANILA",
				"PERPETUAL HELP COLLEGE OF MANILA",
				"PERPETUAL HELP COLLEGE-MANILA",
				"PERPETUAL-HELP COLLEGE OF MANILA");
				
replace school="PERPETUAL HELP PARAMEDICAL SCHOOL" if inlist(school, "PERPETUAL HELP  PARAMEDICAL  SCHOOL",
				"PERPETUAL HELP PARAMEDICAL");
				
replace school="PERPETUAL HELP SCHOOLS" if inlist(school, "PERPETUAL HELP. SCHOOLS",
				"PFRPETUAL HELP SCHOOLS");
				
*CHANGED THE NAME TO MATCH SEARCH RESULTS;
replace school="PHILIPPINE AIRLINES AVIATION SCHOOL" if inlist(school, "PHILIPPINE AIR FLYING SCHOOL");

*PHILIPPINE AIR FORCE COLLEGE OF AERONAUTICS IS NOW PHILIPPINE STATE COLLEGE OF AERONAUTICS;
replace school="PHILIPPINE STATE COLLEGE OF AERONAUTICS- CAVITE" if inlist(school, "PHILIPPINE AIR FORCE COLLEGE OF AERONAOTICS-CAVITE",
				"PHILIPPINE AIR FORCE COLLEGE OF AERONAUTICS - CAVITE");
				
replace school="PHILIPPINE COLLEGE OF HEALTH & SCIENCES" if inlist(school, "PHILLPPINE COLLEGE OF HEALTH AND SCIENCES");
				
replace school="PHILIPPINE STATE COLLEGE OF AERONAUTICS- LIPA CITY" if inlist(school, "PHILIPPINE AIR FORCE COLLEGE OF AERONAUTICS - LIPA CITY");

replace school="PHILIPPINE STATE COLLEGE OF AERONAUTICS- PAMPANGA" if inlist(school, "PHILIPPINE AIR FORCE COLLEGE OF AERONAUTICS - PAMPANGA");

replace school="PHILIPPINE STATE COLLEGE OF AERONAUTICS- LAPU-LAPU" if inlist(school, "PHILIPPINE AIR FORCE COLLEGE OF AERONAUTICS-LAPU-LAPU");

*FOUND THAT PHILIPPINE COLLEGE OF TECHNICAL RESOURCES IS NOW CALLED SAINT LOUIS COLLEGE OF VALENZUELA;
replace school="SAINT LOUIS COLLEGE OF VALENZUELA" if inlist(school, "PHILIPPINE COLLEGE OF TECHNICAL RESOURCES");

				
*UNIVERSITY OF PERPETUAL HELP SYSTEM LAGUNA FORMERLY CALLED PERPETUAL HELP COLLEGE LAGUNA;
replace school="UNIVERSITY OF PERPETUAL HELP SYSTEM LAGUNA" if inlist(school, "PERPETUAL HELP COLLEGE - LAGUNA",
				"PERPETUAL HELP COLLEGE LAGUNA",
				"PERPETUAL HELP COLLEGE OF LAGUNA",
				"PERPETUAL HELP COLLEGE-LAGUNA",
				"PERPETUAL HELP-COLLEGE OF LAGUNA",
				"PERP HELP COL-LAGUNA");
				
*I FOUND THAT MARY JOHNSTON COLLEGE OF NURSING IS PART OF PHILIPPINE CHRISTIAN UNIVERSITY;				
replace school="PHILIPPINE CHRISTIAN UNIVERSITY- MANILA" if inlist(school, "PHILIPPINE CHRISTIAN UNIVERSITY",
				"PHILIPPINE CHRISTIAN UNIVERSITY - MANILA",
				"PHILIPPINE CHRISTIAN UNIVERSITY-MANILA",
				"PHILIPPINE CHRISTIAN UNIVERSITY (MARY JOHNSTON)",
				"PHILIPPINES CHRISTIAN UNIVERSITY - MANILA",
				"MARY JOHNSTON - PCU",
				"MARY JOHNSTON COLLEGE",
				"P. C. U.- MANILA");
				
*ASSUMED CHRISTIAN COLLEGE REFERRED TO PHIL CHRISTIAN COLL WHICH IS NOW UNI;				
replace school="PHILIPPINE CHRISTIAN UNIVERSITY- MANILA" if inlist(school, "CHRISTIAN COLLEGE OF THE PHILIPPINES");


				
replace school="PHILIPPINE COLLEGE OF HEALTH & SCIENCES" if inlist(school, "PHILIPPINE COLLEGE OF HEALTH AND SCIENCES");

replace school="PHILIPPINE COLLEGE OF SCIENCE & TECHNOLOGY- CALASIAO" if inlist(school, "PHILIPPINE COLLEGE OF SCIENCE & TECH. - CALASIAO",
				"PHILIPPINE COLLEGE OF SCIENCE & TECHNOLOGY-CALASIAO");
				
*PHILIPPINE NORMAL COL.-NEGROS OCC. IS NOW PHILIPPINE NORMAL UNIVERISTY;
*FOUND THAT CAVIZ CITY IS THE SAME CAMPUS AS NEGROS OCC;
replace school="PHILIPPINE NORMAL UNIVERSITY- NEGROS OCCIDENTAL" if inlist(school, "PHILIPPINE NORMAL COL.-NEGROS OCC.",
				"PHILIPPINE NORMAL UNIVERSITY-CAOIZ CITY");

				
replace school="PHILIPPINE MERCHANT MARINE SCHOOL - MANILA" if inlist(school, "PHILIPPINE MERCHANT MARINE SCHOOL-MANILA");

replace school="PHILIPPINE REHAB. INSTITUTE FOUNDATION, INC.- GUAGUA,PAMP." if inlist(school, "PHILIPPINE REHAB.INSTITUTE FOUNDATION, INC.- GUAGUA,PAMP.",
				"PHILIPPINE REHAB.INSTITUTE FOUNDATION, INC.-GUAGUA, PAMP.",
				"PHILIPPINE REHAB.INSTITUTE FOUNDATION, INC.-GUAGUA,PAMP.");
				
				
*I ASSUMED THAT ENTRIES WITHOUT SPECIFIED LOCATIONS WERE PART OF QUEZON CITY CAMPUS;
replace school="PHILIPPINE REHAB.INSTITUTE FOUNDATION, INC.- QUEZON CITY" if inlist(school, "PHILIPPINE REHAB.INSTITUTE FOUNDATION, INC.-QUEZON CITY",
				"PHILIPPINE REHABILITATION INSTITUTE FOUNDATION, INC.",
				"PHILIPPINE REHABILITATION INSTITUTE FOUNDATION. INC.");
				
*I ASSUMED ENTRY WITH NO SPECIFIC CAMPUS WAS PART OF QUEZON CITY CAMPUS BUT THERE IS ALSO A MANILA CAMPUS;
replace school="PHILIPPINE SCHOOL OF BUSINESS ADMINISTRATION - QUEZON CITY" if inlist(school, "PHILIPPINE SCHOOL OF BUSINESS ADMINISTRATION-QUEZON CITY",
				"PHILIPPINE SCHOOL OF BUSINESS ADMINISTRATION");
				
generate temp=regexm(school, "^PHILIPPINE WOMEN.*S COLLEGE OF DAVAO$");
replace school="PHILIPPINE WOMEN'S COLLEGE OF DAVAO" if temp==1;
drop temp;
				
*I ASSUMED ENTRY WITH NO SPECIFIC CAMPUS WAS PART OF MANILA CAMPUS;	
*PHILIPPINES WOMENS COLLEGE IS NOW CALLED PHILIPPINE WOMEN'S UNIVERSITY;			
replace school="PHILIPPINE WOMEN'S UNIVERSITY - MANILA" if inlist(school, "PHILIPPINE WOMEN'S UNIVERSITY- MANILA",
				"PHILIPPINE WOMEN'S UNIVERSITY-MANILA",
				"PHILIPPINE WOMEN'S UNIVERSITY",
				"P.W.U. - MANILA");
				
generate temp=regexm(school, "^PHILIPPINE WOMEN.*S UNIVERSITY - MANILA$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - MANILA" if temp==1;
drop temp;

generate temp=regexm(school, "PHILIPPINE WOMEN.*S UNIVERSITY-MANILA$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - MANILA" if temp==1;
drop temp;

generate temp=regexm(school, "^PHILIPPINES WOMEN.*S UNIVERSITY - MANILA$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - MANILA" if temp==1;
drop temp;

generate temp=regexm(school, "^PHILIPPINE WOMEN.*S UNIVERSITY$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - MANILA" if temp==1;
drop temp;
				
replace school="PHILIPPINE WOMEN'S UNIVERSITY - QUEZON CITY" if inlist(school, "PHILIPPINE WOMEN'S UNIVERSITY- QUEZON CITY",
				"PHILIPPINE WOMEN'S UNIVERSITY-QUEZON CITY");
				
generate temp=regexm(school, "^PHILIPPINE WOMEN.*S UNIVERSITY - QUEZON CITY$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - QUEZON CITY" if temp==1;
drop temp;

generate temp=regexm(school, "^PHILIPPINE WOMEN.*S UNIVERSITY- QUEZON CITY$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - QUEZON CITY" if temp==1;
drop temp;

generate temp=regexm(school, "^PHILIPPINE WOMEN.*S UNIVERSITY-QUEZON CITY$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - QUEZON CITY" if temp==1;
drop temp;

generate temp=regexm(school, "^PHILIPPINES WOMEN.*S UNIVERSITY - QUEZON CITY$");
replace school="PHILIPPINE WOMEN'S UNIVERSITY - QUEZON CITY" if temp==1;
drop temp;
				
replace school="PHILIPPINE WOMEN'S UNIVERSITY - QUEZON CITY" if inlist(school, "P.W.U. - QUEZON CITY");				
				
replace school="PILAR COLLEGE" if inlist(school, "PILLAR'S COLLEGE");

replace school="OUR LADY OF THE PILLAR'S COLLEGE" if strpos(school, "OUR LADY OF THE");
				
*PINES CITY EDUCATIONAL CENTER NOW CALLED PINES CITY COLLEGES;
replace school="PINES CITY COLLEGES" if inlist(school, "PINES CITY EDUC CTR",
				"PINES CITY EDUCATION CENTER",
				"PINES CITY EDUCATIONAL CENTER",
				"PINES CITY EDUCATIONAL COLLEGE",
				"PINES CITY COLLEGE (PCEC)");
								
*PINES CITY DOCOTRS HOSPITAL IS PART OF PINES CITY COLLEGES;
replace school="PINES CITY COLLEGES" if inlist(school, "PINES CITY DOCTORS HOSP. SCH. OF NURSING",
				"PINES CITY DOCTORS HOSPITAL SCHOOL OF NURSING");
				
generate temp=regexm(school, "^PINES.* CITY DOCTORS HOSPITAL SCHOOL OF NURSING$");
replace school="PINES CITY COLLEGES" if temp==1;
drop temp;

*PHILIPPINE MARITIME INSTITUTE IS NOW PMI COLLEGES;
*ASSUMED MPI WAS A TYPO;
replace school="PMI COLLEGES- BOHOL" if inlist(school, "PHILIPPINE MARITIME INSTITUTE - BOHOL",
				"MPI COLLEGE - BOHOL",
				"PHILIPPINE MARITIME INSTITUTE- BOHOL");
				
replace school="PMI COLLEGES- MANILA" if inlist(school, "PHILIPPINE MARITIME INSTITUTE - MANILA");
				
replace school="POLYTECHNIC COLLEGE OF DAVAO DEL SUR" if inlist(school, "POLYTECHNIC SCHOOL OF DAVAO DEL SUR",
				"POLYTECHNIC-COLLEGE OF DAVAO DEL SUR");
				
*FOUND THAT PAMETS COLLEGES-LA UNION IS NOW POLYTECHNIC COLLEGE OF LA UNION;
replace school="POLYTECHNIC COLLEGE OF LA UNION" if inlist(school, "PAMETS COLLEGES-LA UNION");
				

*On the website for POLYTECHNIC UNIVERSITY OF THE PHIL there are three regions: Metro Manila, Central Luzon and South Luzon;
*Under the header of each region are several differnent campuses;
*COMBINED MESA AND MANILA BECAUSE SANTA MESA IS IN MANILA AND I THINK BOTH ARE REFERRING TO MAIN CAMPUS;
replace school="POLYTECHNIC UNIVERSITY OF THE PHILIPPINES-MAIN-STA. MESA" if inlist(school, "POLYTECHNIC UNIVERSITY OF THE PHILIPPINES",
				"POLYTECHNIC UNIVERSITY OF THE PHIL.-MANILA");
				
*This has a low number of observations but is listed as a branch on the university website;			
replace school="POLYTECHNIC UNIVERSITY OF THE PHILIPPINES - BATAAN" if inlist(school, "POLYTECHNIC UNIVERSITY OF THE PHILIPPINES-BATAAN");

*This has a low number of observations but is listed as a branch on the university website;			
replace school="POLYTECHNIC UNIVERSITY OF THE PHILIPPINES- TAGUIG CITY" if inlist(school, "POLYTECHNIC UNIVERSITY OF THE PHILIPPINES- TAGUIG");

*FOUND THAT SOUTHERN PACIFIC COLLEGE IS NOW POLYTECHNIC UNI OF THE PHIL- LOPEZ;
replace school="POLYTECHNIC UNIVERSITY OF THE PHILIPPINES- LOPEZ" if inlist(school, "SOUTHERN PACIFIC COLLEGE");


				
*COULDN'T FIND INFO ON NURSING SCHOOL SO ASSUMED IT WAS PART OF MEDICAL CENTER AND COLLEGES;
replace school="QUEZON CITY MEDICAL CENTER & COLLEGES" if inlist(school, "QUEZON CITY MED CTR",
				"QUEZON CITY MEDICAL CENTER",
				"QUEZON CITY MEDICAL CENTER SCH. OF NURSING",
				"QUEZON CITY MEDICAL CENTER SCHOOL OF NURSING",
				"QUEZON MEMORIAL HOSPITAL SCHOOL OF NURSING");
				
replace school="QUEZON MEMORIAL COLLEGE" if inlist(school, "QUEZON MEMORIAL COLLEGES");

*I ASSUMED QUIRINO COLLEGES WAS QUIRINO STATE COLLEGE;
*QUIRINO STATE COLLEGE IS NOW QUIRINO STATE UNIVERSITY;
replace school="QUIRINO STATE UNIVERSITY" if inlist(school, "QUIRINO COLLEGES",
				"QUIRINO STATE COLLEGE");

replace school="RAMON MAGSAYSAY MEMORIAL COLLEGES" if inlist(school, 
				"RAMON MAGSAYSAY MEMORIAL SCHOOL",
				"RAMON MAGSAYSAY MEMORIAL SCHOOL OF NURSING");
				
replace school="PRESIDENT RAMON MAGSAYSAY STATE UNIVERSITY-IBA" if inlist(school, "RAMON KAGSAYSAY POLYTECHNIC COLLEGE");
				

*RAMON MAGSAYSAY TECHNOLOGICAL UNIVERSITY IS NOW CALLED PRESIDENT RAMON MAGSAYSAY STATE UNI;			
*ASSUMED THAT ENTRY WITHOUT CAMPUS WAS PART OF MAIN CAMPUS;
replace school="PRESIDENT RAMON MAGSAYSAY STATE UNIVERSITY-IBA" if inlist(school, "RAMON MAGSAYSAY TECHNOLOGICA L UNIVERSITY-IBA",
				"RAMON MAGSAYSAY TECHNOLOGICAL UNIVERSITY~IBA",
				"RAMON MAGSAYSAY TECHNOLOGICAL UNIVERSITY",
				"RAMON MAGSAYSAY  TECHNOLOGICAL  UNIVERSITY-IBA",
				"RAMON MAGSAYSAY TECHNOLOGICAL UNIVERSITY-IBA");
				
replace school="PRESIDENT RAMON MAGSAYSAY STATE UNIVERSITY- CANDELARIA" if inlist(school, "RAMON MAGSAYSAY TECHNOLOGICAL UNIVERSITY- CANDELARIA");

replace school="PRESIDENT RAMON MAGSAYSAY STATE UNIVERSITY- SAN MARCELINO" if inlist(school, "RAMON MAGSAYSAY TECHNOLOGICAL UNIVERSITY-SAN MARCELINO");
				
*I THINK MEMORIAL SCHOOL AND MEDICAL FOUNDATION ARE DIFFERENT; 		
replace school="REMEDIOS T. ROMUALDEZ MEDICAL FOUNDATION" if inlist(school, "REMEDIOS T. ROMUALDEZ MEDICAL FNDTN.",
				"REMEDIOS T. ROMOALDEZ MEDICAL FOUNDATION COLLEGE OF MEDICINE",
				"REMEDIOS T. ROMUALDEZ MEDICAL FOUNDATION COLLEGE OF MEDICINE",
				"REMEDIOS T. ROMUALDEZ MEDICAL FOUNDATION COLLEGE OF NURSING",
				"R.T. ROMUALDEZ MEDICAL FOUND. COLLEGE OF MEDICINE",
				"R.T. ROMUALDEZ MEDICAL FOUNDATION",
				"R.T. ROMUALDEZ MEDICAL FOUND.COL. OF MEDICINE");
				
replace school="REMEDIOS T. ROMUALDEZ MEDICAL FOUNDATION" if inlist(school, "R.T.ROMUALDEZ-CO.MED");
				

*FOUND THAT REMEDIOS T. ROMUALDEZ MEMORIAL SCHOOL IS NOW CALLED MAKATI MEDICAL CENTER COLLEGE;
replace school="MAKATI MEDICAL CENTER COLLEGE" if inlist(school, "REMEDIOS T. ROMUALDEZ MEMORIAL",
				"REMEDIOS T. ROMUALDEZ MEMORIAL COLLEGE",
				"REMEDIOS T. ROMUALDEZ MEMORIAL SCHOOL",
				"REMEDIOS TRINIDAD ROMUALDEZ MEMORIAL SCHOOL",
				"R.TRINIDAD ROMUALDEZ MEMORIAL SCHOOL",
				"R. T. ROMUALDEZ MEM. (MAKATI MEDICAL CENTER)",
				"R. TRINIDAD MEM SCH",
				"REMEDIOS T. ROMUALDEZ MEMORIAL SCHOOL");
				
replace school="REPUBLIC CENTRAL COLLEGES" if inlist(school, "REPUBLIC COLLEGES");

replace school="RIZAL TECHNOLOGICAL UNIVERSITY" if inlist(school, "RIZAL TECHNOLOGICAL COLLEGE",
				"RIZAL  TECHNOLOGICAL  UNIVERSITY");
				
*ROMBLON STATE COLLEGE IS NOW CALLED ROMBLON STATE UNIVERSITY;
replace school="ROMBLON STATE UNIVERSITY" if inlist(school, "ROMBLON STATE COLLEGE");
				
replace school="ROOSEVELT COLLEGE- CAINTA" if inlist(school, "ROOSEVELT  COLLEGE-CAINTA",
				"ROOSEVELT COLLEGE-CAINTA");
				

*ASSUMED SACRED HEART SCHOOL OF NURSING WAS PART OF SACRED HEART COLLEGE- LUCENA;	
*SACRED HEART COLLEGE - LUCENA IS NOW CALLED ST. MARY'S COLLEGE OF CATBALOGAN (SACRED HEART COLL.);	
*CBT: I think Lucena and Catblogan are distinct;	
replace school="SACRED HEART COLLEGE OF LUCENA CITY, INC." if inlist(school, "SACRED HEART COLLEGE",
				"SACRED HEART COLLEGE OF LUCENA CITY, INC.",
				"SACRED HEART COLLEGE OF LUCENA CITY. INC.",
				"SACRED HEART SCHOOL OF NURSING",
				"SAGRED-HEART COLLEGE OF LUCENA CITY, INC.",
				"SACRED HEART COLLEGE - LUCENA");
				
*SAINT ANNE'S SCHOOL OF MEDICAL SCIENCES is now called SAINT ANNE COLLEGE LUCENA, INC;
*SAINT ANNE COLLEGE LUCENA, INC IS NOW CALLED SAINT ANNE COLLEGE OF THE PACIFIC;
replace school="SAINT ANNE COLLEGE OF THE PACIFIC" if inlist(school, "SAINT ANNE COLLEGE LUCENA, INC",
				"SAINT ANNE COLLEGE LUCENA. INC.",
				"SAINT ANNE COLLEGE LUCENA, INC.");
				
replace school="SAINT ANNE'S HOSPITAL SCHOOL OF NURSING" if inlist(school, "SAINT'ANNE'S HOSPITAL SCHOOL OF NURSING");
				
				
*ASSUMED SMD WAS ABBREVIATION FOR SAFFRULLAH M. DIPATUAN; 				
replace school="SAFFRULLAH M. DIPATUAN FOUNDATION ACADEMY-MARAWI CITY" if inlist(school, "SMD FOUNDATION ACADEMY");

				
*SAINT ANNE'S HOSPITAL IS LEGIT BUT I COULD FIND NO INFO ON NURSING SCHOOL BESIDES EMPTY FACEBOOK PAGE AND ALUMNINET;
*CBT: I think this is part of the Saint Anne's Lucerna, as there is a hospital there;
generate temp=regexm(school, "^SAINT ANNE.*S HOSPITAL SCHOOL OF NURSING$");
replace school="SAINT ANNE COLLEGE OF THE PACIFIC" if temp==1;
drop temp;

replace school="SAINT ANNE COLLEGE OF THE PACIFIC" if inlist(school, "ST. ANNE'S SCHOOL OF NURSING");
				
generate temp=regexm(school, "^SAINT ANNE.*S SCHOOL OF MEDICAL SCIENCES INC.$");
replace school="SAINT ANNE COLLEGE OF THE PACIFIC" if temp==1;
drop temp;


*SAINT ANTHONY COLLEGE USED TO BE CALLED SAINT ANTHONY SCHOOL OF NUSRING AND MIDWIFERY;
*I ASSUMED SAINT ANTHONY'S SCHOOL IS PART OF SAINT ANTHONY COLLEGE- ROXAS CITY;
*CBT: I reassigned St. Anthony College to Antique. Both having nursing programs;
replace school="SAINT ANTHONY COLLEGE - ROXAS CITY" if inlist(school, "SAINT ANTHONY COLLEGE - R0XAS CITY",
				"SAINT ANTHONY COLLEGE OF ROXAS CITY",
				"SAINT ANTHONY'S COLLEGE - ROXAS CITY",
				"SAINT ANTHONY'S COLLEGE-ROXAS CITY",
				"ST. ANTHONY COLLEGE - ROXAS CITY",
				"SAINT AUGUSTINE COLLEGE OF ROXAS CITY");
				
replace school="SAINT ANTHONY'S COLLEGE - ANTIQUE" if inlist(school, 
				"SAINT ANTHONY'S SCHOOL",
				"ST. ANTHONY COLLEGE");
				
generate temp=regexm(school, "^SAINT ANTHONY.*S SCHOOL$");
replace school="SAINT ANTHONY'S COLLEGE - ANTIQUE" if temp==1;
drop temp;
				
generate temp=regexm(school, "^SAINT ANTHONY.*S COLLEGE - ROXAS CITY$");
replace school="SAINT ANTHONY COLLEGE - ROXAS CITY" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT ANTHONY.*S COLLEGE-ROXAS CITY$");
replace school="SAINT ANTHONY COLLEGE - ROXAS CITY" if temp==1;
drop temp;

generate tempe=regexm(school, "^ST. ANTHONY.*S COLLEGE$");
replace school="SAINT ANTHONY'S COLLEGE - ANTIQUE" if temp==1;
drop temp;

replace school="SAINT ANTHONY COLLEGE- CALAPAN" if inlist(school, "SAINT ANTHONY COLLEGE-CALAPAN");

replace school="SAINT ANTHONY'S COLLEGE- ANTIQUE" if inlist(school, "SAINT ANTHONY'S COLLEGE-ANTIQUE");

generate temp=regexm(school, "^SAINT ANTHONY.*S COLLEGE - ANTIQUE$");
replace school="SAINT ANTHONY'S COLLEGE- ANTIQUE" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT ANTHONY.*S COLLEGE-ANTIQUE$");
replace school="SAINT ANTHONY'S COLLEGE- ANTIQUE" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT ANTHONY.*S COLLEGE OF TECHNOLOGY$");
replace school="SAINT ANTHONY'S COLLEGE OF TECHNOLOGY" if temp==1;
drop temp;

replace school="SAINT BENEDICT  COLLEGE-COTABATO  CITY" if inlist(school, "SAINT BENEDICT COLLEGE - C0TABATO CITY",
				"SAINT BENEDICT COLLEGE- COTABATO CITY",
				"SAINT BENEDICT COLLEGE-COTABATO CITY");
				
replace school="SAINT CATHERINE COLLEGE" if inlist(school, "ST. CATHERINE COLLEGE");
				
*FEW OBSERVATIONS BUT LEGIT;
replace school="SAINT COLUMBAN COLLEGE-PAGADIAN CITY" if inlist(school, "SAINT COLUMBAN COLLEGE");
				
replace school="SAINT DOMINIC COLLEGE OF BATANES" if inlist(school, "SAINT DOMINIC COLLEGE",
				"SAINT DOMINIC COLLEGE OF 9ATANES");

replace school="SAINT DOMINIC SAVIO COLLEGE" if inlist(school, "SAINT DOMINIC SAVI0 COLLEGE",
				"ST. DOMINIC SAVIO COLLEGE");

replace school="SAINT FERDINAND COLLEGE- ILAGAN" if inlist(school, "SAINT FERDINAND C0LLEGE-ILAGAN",
				"SAINT FERDINAND COLLEGE",
				"SAINT FERDINAND COLLEGE-ILAGAN");
				
replace school="SAINT FRANCIS OF ASSISI COLLEGE" if inlist(school, "SAINT FRANCIS OF ASSISSI COLLEGE");

replace school="SAINT FRANCIS COLLEGE - GUIHULNGAN" if inlist(school, "SAINT FRANCIS COLLEGE-GUIHULNGAN");

replace school="SAINT GABRIEL COLLEGE - ANTIQUE" if inlist(school, "SAINT GABRIEL COLLEGE-ANTIQUE");

*ASSUMED ENTRY WITHOUT CAMPUS IS PART OF KALIBO BECAUSE COULDN'T FIND INFO ON ANTIQUE CAMPUS;
replace school="SAINT GABRIEL COLLEGE- KALIBO" if inlist(school, "SAINT GABRIEL C0LLEGE-KALIB0",
				"SAINT GABRIEL COLLEGE",
				"SAINT GABRIEL COLLEGE - KALI80",
				"SAINT GABRIEL COLLEGE - KALIBO",
				"SAINT GABRIEL COLLEGE-KALIBO",
				"SALNT GABRIEL COLLEGE - KALIBO",
				"ST. GABRIEL COLLEGE");
				
*SAINT JAMES COLLEGE OF CALAMBA IS PERMANENTLY CLOSED; 				
				
replace school="SAINT JOHN COLLEGES- CALAMBA" if inlist(school, "SAINT JOHN COLLEGE-CALAMBA",
				"SAINT JOHN COLLEGE- CALAMBA");


replace school="SAINT JOSEPH COLLEGE-CAVITE CITY" if inlist(school, "SAINT JOSEPH COLLEGE - CAVITE CITY",
				"SAINT JOSEPHCOLLEGE - CAVITE CITY",
				"SAINT JOSFPH COLLEGE - CAVITE CITY");

*ASSUMED SAINT JOSEPH COLLEGE IS PART OF SAINT JOSEPH'S COLLEGE- QUEZON CITY;
replace school="SAINT JOSEPH'S COLLEGE - QUEZON CITY" if inlist(school, "SAINT JOSEPH'S COLLEGE OF QUEZON CITY",
				"SAINT JOSEPH COLLEGE",
				"ST. JOSEPH COLLEGE");

replace school="SAINT JOSEPH INSTITUTE OF TECHNOLOGY" if inlist(school, "SAINT JOSEPH'S INSTITUTE OF TECHNOLOGY");

generate temp=regexm(school, "^SAINT JOSEPH.*S CQLLEGE-MAASIN$");
replace school="SAINT JOSEPH'S COLLEGE- MAASIN" if temp==1;
drop temp;

*ST LOUIS COLLEGE IS NOW CALLED SAINT LOUIS UNIVERSITY;
*Note: St. Louis College in La Union does not have a nursing program;
replace school="SAINT LOUIS UNIVERSITY" if inlist(school, "SAINT LOUIS COLLEGE - MANILA",
				"SAINT LOUIS COLLEGE",
				"ST. LOUIS UNIVERSITY");
				
*IMMACULATE CONCEPTION COLLEGE - MARINDUQUE IS NOW CALLED SAINT MARY’S COLLEGE OF MARINDUQUE;
replace school="SAINT MARY’S COLLEGE OF MARINDUQUE" if inlist(school, "IMMACULATE CONCEPTION COLLEGE - MARINDUQUE");

*SAINT MARY COLLEGE IS NOW CALLED SAINT MARY'S UNIVERSITY;
replace school="SAINT MARY'S UNIVERSITY" if inlist(school, 
				"SAINT MARY'S UNIVERSITY (FOR. ST.MARY'S COLL.- BAYOMBONG)",
				"SAINT MARY'S UNIVERSITY (FOR. ST.MARY'S COLL.-BAYOMBONG)",
				"SAINT MARY'S UNIVERSITY (FOR. ST.MARY'S COLL.-BAYONBONG)");
				
generate temp=regexm(school, "^SAINT MARY.*S UNIVERSITY$");
replace school="SAINT MARY'S UNIVERSITY" if temp==1;
drop temp;

*SAINT MARY"S WAS CUT OFF in JUNE 2009;
*COLLEGE OF SAN JUAN WAS MISSING THROUHGOUT SO NUMBERS WON"T BE OFF;
*Break in PDF caused two entries;
replace school="SAINT MARY'S COLLEGE OF SAN JUAN" if school=="SAINT MARY'S";

replace school="SAINT MICHAEL'S COLLEGE-ILIGAN CITY" if inlist(school, "SAINT MICHAEL'S COLLEGE- ILIGAN CITY");

replace school="SAINT MICHAEL'S COLLEGE OF LAGUNA" if inlist(school, "SAINT MICHAEL'S  COLLEGE OF LAGUNA",
				"SAINT MICHAEL'S COLLEGE'OFLAGUNA");
				
generate temp=regexm(school, "^SAINT MICHAEL.*S COLLEGE OF LAGUNA$");
replace school="SAINT MICHAEL'S COLLEGE OF LAGUNA" if temp==1;
drop temp;
				
replace school="SAINT PAUL COLLEGE FOUNDATION, INC (CEBU-ST PAUL COLL)" if inlist(school, "SAINT PAUL COLLEGE  FOUNDATION, INC  (CEBU-ST PAUL COLL)",
				"SAINT PAUL COLLEGE FOUNDATION, INC (CE8U-ST PAUL COLL)",
				"SAINT PAUL COLLEGE FOUNDATION,- INC (CEBU-ST PAUL COLL)",
				"SAINT PAUL COLLEGE FOUNDATION. INC (CEBU-ST PAUL COLL)",
				"FOUNDATION, INC (CEBU-ST PAUL COLL)");
				
*I FOUND THAT ILOCOS SUR AND BANTAY REFER TO THE SAME LOCATION/CAMPUS;
*MEMBER SCHOOL OF THE SAINT PAUL UNIVERSITY SYSTEM;
*ASSUMED ENTRY WITHOUT CAMPUS WAS PART OF ILOCOS SUR CAMPUS;
*THERE IS A SAINT PAUL'S COLLEGE IN PASIG BUT IT APPEARS TO BE AN ALL GIRLS HIGH SCHOOL SO I I ASSUMED ALL SAINT PAUL COLLEGE ENTRIES WERE PART OF ILOCOS SUR;
replace school="SAINT PAUL COLLEGE- ILOCOS SUR" if inlist(school, "SAINT PAUL COLLEGE-  BANTAY(ST.PAUL-  VIGAN)",
				"SAINT PAUL COLLEGE- BANTAY(ST.PAUL- VIGAN)",
				"SAINT PAUL COLLEGE- BANTAY(ST.PAUL-VIGAN)",
				"SAINT PAUL COLLEGE-BANTAY(ST.PAUL-VIGAN)",
				"SAINT PAUL COLLEGE",
				"SAINT PAUL'S COLLEGE");
				
*THIS LINE WONT WORK-ASK;
replace school="SAINT PAUL COLLEGE- ILOCOS SUR" if inlist(school, "SAINT PAUL COLLEGE OF ILOCOS SUR");

generate temp=regexm(school, "^SAINT PAUL.*S COLLEGE$");
replace school="SAINT PAUL COLLEGE- ILOCOS SUR" if temp==1;
drop temp;

*COLEGIO DE SANTA RITA IS NOW SAINT RITA COLLEGE- MANILA;
replace school="SAINT RITA COLLEGE- MANILA" if inlist(school, "SAINT RITA'S COLLEGE",
				"SAINT RITA'S COLLEGE - MANILA",
				"SAINT RITA'S COLLEGE- MANILA",
				"SAINT RITA'S COLLEGE-MANILA",
				"SAINT RITA'S-COLLEGE - MANILA",
				"COLEGIO DE SANTA RITA",
				"COLEGIO DE STA RITA");
				
generate temp=regexm(school, "^SAINT SCHOLASTICA.*S COLLEGE$");
replace school="SAINT SCHOLASTICA'S COLLEGE" if temp==1;
drop temp;
				
replace school="SAINT THERESE-MTC COLLEGE- ILOILO CITY" if inlist(school, "SAINT THERESE-MTC C0LLEGE-IL0ILO CITY",

				"SAINT THERESE-MTC COLLEGE-ILOILO CITY");
				
*SAN BEDA COLLEGE IS NOW CALLED SAN BEDA UNIVERSITY;
replace school="SAN BEDA UNIVERSITY" if inlist(school, "SAN BEDA COLLEGE");

*I ASSUMED SAN JOSE COLLEGES WAS COLEGIO DE SAN JOSE;
*CBT: No, this is in Nueva Ecija;
*replace school="COLEGIO DE SAN JOSE" if inlist(school, "SAN JOSE COLLEGES");

*I ASSUMED SAN LORENZO RUIZ COLLEGE FOR RESEARCH & STUDIES IS SAN LOR CENTER OF STUDIES AND SCHOOLS;
replace school="SAN LORENZO CENTER OF STUDIES AND SCHOOLS" if inlist(school, "SAN LORENZO RUIZ COLLEGE FOR RESEARCH & STUDIES");   

replace school="SAN JUAN DE DIOS EDUCATIONAL FOUNDATION, INC" if inlist(school, "SAN JUAN DE DIOS EDUCATIONAL  FOUNDATION, INC",
				"SAN JUAN DE DIOS EDUCATIONAL FOUND, INC.",
				"SAN JUAN DE DIOS EDUCATIONAL FOUND. INC.",
				"SAN JUAN DE DIOS EDUCATIONAL FOUNDATION. INC",
				"SAN JUAN DE- DIOS EDUCATIONAL FOUNDATION. INC",
				"SAN JUAN OE OIOS EDUCATIONAL FOUNDATION, INC",
				"SAN JUAN DE DIOS COLLEGE");

replace school="SAN PABLO COLLEGES" if inlist(school, "SAN PABLO COLLEGE");

replace school="SAN PEDRO COLLEGE- DAVAO CITY" if inlist(school, "SAN PEDRO  COLLEGE-DAVAO  CITY",
				"SAN PEDRO COLLEGE - DAVAO CITY",
				"SAN PEDRO COLLEGE DAVAO CITY",
				"SAN PEDRO COLLEGE-DAVAO CITY",
				"SAN PEDRO COLLEGE",
				"SAN PEDRO HOSPITAL SCHOOL OF NURSING");
				
replace school="SAN SEBASTIAN COLLEGE- RECOLETOS,CAVITE" if inlist(school, "SAN SEBASTIAN COLLEGE-  RECOLETOS,CAVITE",
				"SAN SEBASTIAN COLLEGE- RECOLETOS,CAVIT E",
				"SAN SEBASTIAN COLLEGE-RECOLETOS,CAVITE");
				
replace school="SAN SEBASTIAN COLLEGE- RECOLETOS" if inlist(school, "SAN SEBASTIAN COLLEGE - MANILA",
				"SAN SEBASTIAN COLLEGE-RECOLETOS");
				
replace school="SCHOOL" if inlist(school, "SCHOOL FOUNDATION");
			
				
replace school="SAINTS JOHN AND PAUL COLLEGES-CALAMBA" if inlist(school, "SAINTS JOHN AND PAUL COLLEGES- CALAMBA");

replace school="SALAZAR INSTITUTE OF TECHNOLOGY- CEBU CITY" if inlist(school, "SALAZAR INSTITUTE OF TECHNOLOGY-CEBU CITY");

*I ASSUMED SAMSON TECHNICAL SCHOOL IS SAMSON COLLEGE OF SCIENCE AND TECHNOLOGY;
replace school="SAMSON COLLEGE OF SCIENCE AND TECHNOLOGY" if inlist(school, "SAMSON TECHNICAL SCHOOL");

*ASSUMED SCHOOL OF NURSING WAS PARTOF MEMORIAL COLLEGE;
replace school="SCOUT RAMON V. ALBANO MEMORIAL COLLEGE" if inlist(school, "SCOUT RAMON V, ALBANO COLLEGE",
				"SCT. ALBANO MEM COLLEGE",
				"SET. RAMON ALBANO MEMORIAL COLLEGE",
				"SCOUT RAMON ALBANO SCHOOL OF NURSING",
				"SCOUT RAHOH ALBANO HEH. COLL.(ST RITA HOSP & SCH NUR & MID)",
				"SCOUT RAMON ALBANO MEM, COLLEGE (ST RITA HOSP & SCH NUR & MID)",
				"SCOUT RAMON ALBANO MEM. COLL.(ST RITA HOSP & SCH NUR &  MID)",
				"SCOUT RAMON ALBANO MEM. COLL.(ST RITA HOSP & SCH NUR & HID)",
				"SCOUT RAMON ALBANO MEM. COLL.(ST RITA HOSP & SCH NUR & MID)");
				
replace school="SCOUT RAMON V. ALBANO MEMORIAL COLLEGE" if inlist(school, "SCOOT RAMON V. ALBANO MEMORIAL COLLEGE",
				"SCOUT KAMON ALBANO COLLEGE");
				
replace school="SIENA COLLEGE OF TAYTAY" if inlist(school, "SIENNA COLLEGE OF TAYTAY");
				
replace school="SILLIMAN UNIVERSITY" if inlist(school, "SILIMAN UNIVERSITY");

replace school="SOUTH COTABATO SCHOOL OF MIDWIFERY" if inlist(school, "SCOUT COTABATO SCHOOL OF MIDWIFERY");

replace school="SOUTHERN BICOL COLLEGES" if inlist(school, "SOUTHERN BIC0L COLLEGES",
				"SOUTHERN BICOL COLLEGE");
				
replace school="SOUTHERN MARAMAG COLLEGES" if inlist(school, "MARAMAG COLLEGES");

replace school="SOUTHERN PHILIPPINES COLLEGE" if inlist(school, "SOUTHERN PHILIPPINE COLLEGE");

replace school="ST. JOSEPH COLLEGE-AMAYA, INC" if inlist(school, "ST. JOSEPH COLLEGE-AMAYA. INC");

replace school="SAINT JOSEPH COLLEGE-CAVITE CITY" if inlist(school, "ST. JOSEPH  COLLEGE-CAVITE  CITY",
				"ST. JOSEPH COLLEGE-CAVITE CITY",
				"ST. JOSEPH'S COLLEGE -CAVITE",
				"ST. JOSEPH'S COLLEGE CAVITE",
				"SAINT JOSEPH COLLEGE -  CAVITE CITY",
				"ST. JOSEPH COLLEGE- CAVITE CITY");
				
				
generate temp=regexm(school, "^SAINT JOSEPH.*S COLLEGE OF QUEZON CITY$");
replace school="SAINT JOSEPH'S COLLEGE - QUEZON CITY" if temp==1;
drop temp;

replace school="ST. JUDE COLLEGE-DASMARLNAS, CAVITE, INC." if inlist(school, "ST. JUDE COLLEGE- DASMARINAS",
				"ST. JUDE COLLEGE-DASMARINAS, INC");
				
generate temp=regexm(school, "^ST. JUDE COLLEGE-DASMARI.*AS, CAVITE, INC.$");
replace school="ST. JUDE COLLEGE-DASMARLNAS, CAVITE, INC." if temp==1;
drop temp;

generate temp=regexm(school, "ST. JUDE COLLEGE- DASMARI.*AS, CAVITE, INC.$");
replace school="ST. JUDE COLLEGE-DASMARLNAS, CAVITE, INC." if temp==1;
drop temp;

generate temp=regexm(school, "^ST. JUDE COLLEGE- DASMARI.*AS, CAVITY, INC.$");
replace school="ST. JUDE COLLEGE-DASMARLNAS, CAVITE, INC." if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT LUKE.*S SCHOOL OF NURSING$");
replace school="SAINT LUKE'S SCHOOL OF NURSING" if temp==1;
drop temp;

*SAINT LUKES SCHOOL OF NURSING is an educational unit of Trinity University Asia;
*I assumed SAINT LUKES COLLEGE FOUNDATION was part of SAINT LUKES COLLEGE OF NURSING;
replace school="SAINT LUKES COLLEGE OF NURSING-TRINITY UNIVERSITY" if inlist(school, "ST. LUKES HOSPITAL (TRINITY COLLEGE)",
				"ST. LUKES SCHOOL OF NURSING (TRINITY COLLEGE OF Q. C.)",
				"ST. LUKE COLLEGE FOUNDATION",
				"SAINT LUKE COLLEGE FOUNDATION",
				"SAINT LUKE-COLLEGE FOUNDATION");
				
replace school="SAINT LUKES COLLEGE OF NURSING-TRINITY UNIVERSITY" if inlist(school, "SAINT LUKE'S SCHOOL OF NURSING");

generate temp=regexm(school, "^ST. MARY.*S COLLEGE OF 8ALIUAG$");
replace school="ST. MARY'S COLLEGE OF BALIUAG" if temp==1;
drop temp;

generate temp=regexm(school, "^ST. MARY.*S COLLEGE OF BALIUAG$");
replace school="ST. MARY'S COLLEGE OF BALIUAG" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MARY.*S COLLEGE-TAGUM$");
replace school="SAINT MARY'S COLLEGE-TAGUM" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MARY.*S COLLEGE-Q.C.$");
replace school="SAINT MARY'S COLLEGE-Q.C." if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MARY.*S COLLEGE - ILOCOS SUR$");
replace school="SAINT MARY'S COLLEGE ILOCOS SUR" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MARY.*S COLLEGE-ILOCOS SUR$");
replace school="SAINT MARY'S COLLEGE ILOCOS SUR" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MARY.*S COLLEGE OF MEYCAUAYAN$");
replace school="SAINT MARY'S COLLEGE OF MEYCAUAYAN" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MARY.*S COLLEGE OF SAN JUAN$");
replace school="SAINT MARY'S COLLEGE OF SAN JUAN" if temp==1;
drop temp;


generate temp=regexm(school, "^SAINT MARY.*S UNIVERSITY FOR ST. MARY'S COLLEGE - BAYOMBONG$");
replace school="SAINT MARY'S UNIVERSITY" if temp==1;
drop temp;
replace school="SAINT MARY'S UNIVERSITY" if strpos(school,"-BAYOMBONG");

generate temp=regexm(school, "^SAINT JOSEPH.*S INSTITUTE OF TECHNOLOGY$");
replace school="SAINT JOSEPH INSTITUTE OF TECHNOLOGY" if temp==1;
drop temp;

			
replace school="SAINT JUDE COLLEGE- MANILA" if inlist(school, "SAINT JUDE COLLEGE",
				"SAINT JUDE COLLEGE-MANILA",
				"ST. JUDE COLLEGE"); 
				
				
generate temp=regexm(school, "^SAINT MICHAEL.*S COLLEGE - ILIGAN CITY$");
replace school="SAINT MICHAEL'S COLLEGE-ILIGAN CITY" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT MICHAEL.*S COLLEGE-ILIGAN CITY$");
replace school="SAINT MICHAEL'S COLLEGE-ILIGAN CITY" if temp==1;
drop temp;

*THE ONLY ST MICHAEL'S HOSPITAL I COULD FIND IS IN TORONTO AND THEY DO MISSION WORK IN THE PHILIPPINES BUT ITS NOT A SCHOOL;
*ST MICHAEL'S COLLEGE IN ILIGAN CITY HAS A COLLEGE OF NURSING SO I ASSUMED ST MICH HOSPTIAL AND ST MICH HOS AND SC OF NURS WAS PART OF ST MICH COLLEGE;
replace school="ST MICHAEL'S COLLEGE- ILLIGAN CITY" if inlist(school, "ST. MICHAEL HOSPITAL",
				"ST. MICHAEL HOSPITAL SCH. OF NURSING",
				"ST. MICHAEL'S COLLEGE",
				"SAINT MICHAEL'S COLLEGE-ILIGAN CITY");

replace school="ST. MICHAEL COLLEGE LAGUNA" if inlist(school, "SAINT MICHAEL'S COLLEGE OF LAGUNA");

*FEW OVSERVATIONS BUT THERE IS A COLLEGE WEBSITE SO SEEMS LEGIT;
replace school="SAINT MICHAEL COLLEGE OF HINDANG, LEYTE INC" if inlist(school, "SAINT MICHAEL COLLEGE-HINDANG, LEYTE",
				"SAINT MICHAEL CQLLEGE-HINDANG, LEYTE");

replace school="SAINT PAUL COLLEGE- ILOCOS SUR" if inlist(school, "SAINT PAUL COLLEGE OF ILOCOS SUR-BANTAY");
				
replace school="SAINT PAUL UNIVERSITY- DUMAGUETE" if inlist(school, "SAINT PAUL  UNIVERSITY-  DUMAGUETE",
				"SAINT PAUL COLLEGE OF DUMAGUETE",
				"SAINT PAUL COLLEGE OF DUMAGUETE CITY",
				"SAINT PAUL UNIVERSITY-DUMAGUETE",
				"SAINT PAUL COLLEGE - DUMAGUETE",
				"SAINT PAULCOLLEGE- DUMAGUETE",
				"SAINT PAUL COLLEGE- DUMAGUETE",
				"ST. PAUL - DUMAGUETE",
				"ST. PAUL COLLEGE DUMAGUETE");
				
*SAINT PAUL COLLEGE OF DUMAGUETE IS NOW SAINT PAUL UNI;			
replace school="SAINT PAUL UNIVERSITY- DUMAGUETE" if inlist(school, "SALNT PAUL COLLEGE OF DUMAGUETE");
				
replace school="SAINT PAUL UNIVERSITY- ILOILO" if inlist(school, "SAINT PAUL UNIVERSITY-ILOILO",
				"SAINT PAUL COLLEGE OF ILOILO",
				"ST. PAUL COL.- ILOILO",
				"ST. PAUL COLLEGE - ILOILO",
				"ST. PAUL COLLEGE ILOILO");
				
*ASSUMED SAINT PAUL COLLEGE WAS SAINT PAUL UNIVERSITY;
replace school="SAINT PAUL UNIVERSITY- MANILA" if inlist(school, "SAINT PAUL COLLEGE - MANILA",
				"SAINT PAUL COLLEGE OF MANILA",
				"SAINT PAUL UNIVERSITY-MANILA",
				"ST. PAUL COLLEGE - MANILA",
				"ST. PAUL COLLEGE MANILA");
				
*SAN NICOLAS COLLEGE IS NOW CALLED SAINT PAUL UNIVERSITY- SURIGAO;				
replace school="SAINT PAUL UNIVERSITY- SURIGAO" if inlist(school, "SAINT PAUL UNIVERSITY-SURIGAO",
				"SAINT PAUL UNIVERSITY SYSTEM-SURIGAO",
				"SAN NICOLAS COLLEGE");
				
*ASSUMED ENTRY WITHOUT SPECIFIC CAMPUS WAS PART OF TUGUEGARAO CAMPUS;			
replace school="SAINT PAUL UNIVERSITY- TUGUEGARAO" if inlist(school, "SAINT PAUL UNIVERSITY",
				"SAINT PAUL UNIVERSITY - TUGUEGARAO",
				"SAINT PAUL UNIVERSITY ......",
				"SAINT PAUL UNIVERSITY-TUGUEGARAO",
				"SAINT PAUL  UNIVERSITY-  TUGUEGARAO",
				"ST. PAUL UNIVERSITY - TUGUEGARAO",
				"ST. PAUL UNIVERSITY TUGUEGARAO",
				"ST. PAUL UNIVERSITY",
				"ST. PAUL COLLEGE");
				
replace school="SAINT PAUL UNIVERSITY- QUEZON CITY" if inlist(school, "SAINT PAUL UNIVERSITY-QUEZON CITY",
				"SAINT PAUL COLLEGE OF QUEZON CITY",
				"SAINT PAUL  UNIVERSITY-QUEZON  CITY");
				
*SAINT RITA'S COLLEGE MANILA- CHECK;		
generate temp=regexm(school, "^SAINT RITA.*S COLLEGE - MANILA$");
replace school= "SAINT RITA'S COLLEGE- MANILA" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT RITA.*S COLLEGE - PAMPANGA$");
replace school="SAINT RITA COLLEGE - PAMPANGA" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT RITA.*S COLLEGE - PARANAQUE$");
replace school="SAINT RITA COLLEGE - PARANAQUE" if temp==1;
drop temp;

*SAINT RITA COLLEGE-MANILA is the only SAINT RITA with a website and there is very little info about the PARANAQUE branch but I did find an address for it;
*I assumed SAINT RITA entries without campus were part of MANILA;
replace school="SAINT RITA COLLEGE - PAMPANGA" if inlist(school, "SAINT RITA'S COLLEGE PAMPANGA");

generate temp=regexm(school, "SAINT RITA.*S COLLEGE-MANILA$");
replace school="SAINT RITA'S COLLEGE- MANILA" if temp==1;
drop temp;


generate temp=regexm(school, "^SAINT RITA.*S COLLEGE$");
replace school="SAINT RITA'S COLLEGE" if temp==1;
drop temp;

generate temp=regexm(school, "^ST. RITA.*S COLLEGE$");
replace school="SAINT RITA'S COLLEGE" if temp==1;
drop temp;

replace school="SAINT RITA'S COLLEGE- MANILA" if inlist(school, "SAINT RITA COLLEGE- MANILA",
				"SAINT RITA'S COLLEGE",
				"SAINT RITA COLLEGE");

*I ASSUMED STO RITA HOSPITAL SCH. OF NURSING A WAS PART OF THIS;
replace school="SAINT RITA COLLEGE OF NURSING & MIDWIFERY" if inlist(school, "ST. RITA HOSPITAL COLLEGE OF NURSING & SCHOOL OF MIDWIFERY",
				"ST. RITA HOSPITAL COLLEGE OF NURSING I SCHOOL OF MIDWIFERY",
				"STO RITA HOSPITAL SCH. OF NURSING A");
				

replace school="SAINT MARY'S COLLEGE-TAGUM" if inlist(school, "SAINT MARY'S COLLEGE- TAGUM",
				"SAINT MARY'S COLLEGE - TAGUM");
				
generate temp=regexm(school, "SAINT MARY.*S COLLEGE - TAGUM");
replace school="SAINT MARY'S COLLEGE-TAGUM" if temp==1;
drop temp;


generate temp=regexm(school, "^ST. SCHOLASTICA.*S COLLEGE OF HEALTH SCIENCES-TACL08AN$");
replace school="ST. SCHOLASTICA'S COLLEGE OF HEALTH SCIENCES-TACLOBAN" if temp==1;
drop temp;

*FOUND THAT SAINT PAUL COLLEGE OF SAN MIGUEL IS NOW SAINT PAUL UNI SAN MIGUEL;
replace school="SAINT PAUL UNIVERSITY- SAN MIGUEL" if inlist(school, "SAINT PAUL COLLEGE OF SAN MIGUEL");

generate temp=regexm(school, "^SAINT PAUL.*S COLLEGE OF PARANAQUE$");
replace school="SAINT PAUL'S COLLGE OF PARANAQUE" if temp==1;
drop temp;

generate temp=regexm(school, "^SAINT THERESA.*S COLLEGE$");
replace school="SAINT THERESE-MTC COLLEGE- ILOILO CITY" if temp==1;
drop temp;

replace school="SAINT THERESA COLLEGE-TANDAG" if school=="SAINT THERESAS COLLEGE";

*ST THERESE- LA FIESTA AND MARITIME TRAINING CENTER IS NOW CALLED ST. THERESE- MTC COLLEGES;
replace school= "SAINT THERESE-MTC COLLEGE- ILOILO CITY" if inlist(school, "ST. THERESE-MTC COLLEGES-LA FIESTA");

generate temp=regexm(school, "^ST. AUGUSTINE COLLEGE-LAS PI.*AS CITY, INC.-LAS PINAS$");
replace school="ST. AUGUSTINE COLLEGE-LAS PINAS CITY, INC.-LAS PINAS" if temp==1;
drop temp;

replace school="ST. AUGUSTINE COLLEGE- LAS PINAS" if inlist(school, "ST. AUGUSTINE COLLEGE-LAS PINAS CITY, INC.-LAS PINAS");
			
replace school="SAN CARLOS COLLEGE" if inlist(school, "SAN CARLOS-COLLEGE");

*SAN CARLOS SEMINARY ONLY HAS 1 OBSERVATION BUT SEEMS LEGIT;

*ALMOST NO INFO ON SAN PABLO CITY SCHOOL OF ARTS AND TRADE;
replace school="SAN PABLO CITY SCHOOL OF ARTS AND TRADES" if inlist(school, "SAN PABLO CITY SCH. OF ARTS AND TRADES");

*I FOUND INFO THAT SIBUYAN POLYTECHNIC COLLEGE-SIBUYAN WAS PART OF ROMBLON ST UNI;
replace school="ROMBLON STATE UNIVERSITY- SAN FERNANDO CAMPUS" if inlist(school, "SIBUYAN POLYTECHNIC COLLEGE-SIBUYAN");

*SORSOGON SCHOOL OF ARTS AND TRADES IS NOW CALLED SORSOGON STATE COLLEGE;
replace school="SORSOGON STATE COLLEGE" if inlist(school, "SORSOGON SCHOOL OF ARTS AND TRADES");

*NO INFO ON SOUTH COTABATO SCHOOL OF MIDWIFERY;
replace school="SOUTH COTABATO SCHOOL OF MIDWIFERY" if inlist(school, "SOUTH C0TABATO- SCHOOL OF MIDWIFERY");

*UNITED DOCTORS MEDICAL CENTER COLLEGES IS NOW CALLED SOUTHEAST ASIAN COLLEGE;
replace school="SOUTHEAST ASIAN COLLEGE (FORMERLY UDMC)" if inlist(school, "UNITED DOCTOR'S MEDICAL CENTER",
				"UNITED DOCTORS MED",
				"UNITED DOCTORS MEDICAL CENTER",
				"UNITED DOCTORS MEDICAL CENTER SCH. OF NURSING",
				"UNITED DOCTORS MEDICAL CENTER SCHOOL OF NURSING",
				"SOUTHEAST ASIAN",
				"SOUTHEAST ASIAN COLLEGE (FORMERLY UDHC)",
				"SOUTHEAST ASIAN COLLEGE (UDMC)",
				"SOOTHEAST ASIAN COLLEGE (FORMERLY UDMC)");
				
*I INCLUDED THE COLLEGE ENTRY BECAUSE IT HAD UDMC IN PARANTHESIS;
replace school="SOUTHEAST ASIAN COLLEGE (FORMERLY UDMC)" if inlist(school, "COLLEGE (UDMC)");

replace school="SOUTHERN KUDARAT SCHOOL OF MIDWIFERY" if inlist(school, "S. KUDARAT - MDWFRY");			
				
*SOUTHERN LUZON POLYTECHNIC COLLEGE NOW CALLED SOUTHERN LUZON STATE UNIVERSITY;
replace school="SOUTHERN LUZON STATE UNIVERSITY" if inlist(school,
				"SOUTHERN LUZON POLYTECHNIC COLLEGE",
				"SOUTHERN LUZON POLYTECHNIC COLLEGE - LUCBAN",
				"SOUTHERN LUZON POLYTECHNIC COLLEGE- LUCBAN",
				"SOUTHERN LUZON POLYTECHNIC COLLEGE-LUCBAN",
				"SOUTHERN LUZON STATE UNIVERSITY-",
				"SOUTHERN LUZON STATE UNIVERSITY- LUCBAN (SLPC)",
				"SOUTHERN LUZON STATE UNIVERSITY-LUCBAN (SLPC)");
				
replace school="SOUTHERN LUZON STATE UNIVERSITY" if inlist(school, "SO LUZON POLYTEC COLLEGE",
				"SO. LUZON POLYTECHNIC COLLEGE");
				
replace school="SOUTHERN LUZON STATE UNIVERSITY" if inlist(school, "LUCBAN (SLPC)");

replace school="SOUTHERN LUZON STATE UNIVERSITY" if inlist(school, "SOUTHERN LUZON POLYTECHNIC COLLEGE-TAGKAWAYAN");

replace school="SOUTHERN LUZON TECHNOLOGICAL COLLEGE FOUNDATION" if inlist(school, "SOUTHERN LUZON TECHNICAL SCHOOL");

				
replace school="SOUTHERN MASBATE ROOSEVELT COLLEGE" if inlist(school, "SOUTHERN MASBATE ROOSEVELT INSTITUTE",
				"SOUTHERN NASBATE ROOSEVELT INSTITUTE");

replace school="SOUTHERN PHILIPPINES COLLEGE OF SCIENCES & HEALTH EDUCATION" if inlist(school, "SOUTHERN PHILIPPINES COLLEGE OF SCIENCE & HEALTH EDUCATION",
				"SOUTHERN  PHILIPPINES COLLEGE OF SCIENCES & HEALTH EDUCATION");
				
replace school="SOUTHWESTERN UNIVERSITY" if inlist(school, "SOUTHWESTERN UNIVERSITY- COLLEGE OF MEDICINE",
				"SOUTHWESTERN UNIVERSITY-COLLEGE OF MEDICINE",
				"SOUTHWESTERN  UNIVERSITY",
				"SOUTHWESTER N UNIVERSITY",
				"SOUTHWESTER N UNIVERSITY-COLLEGE OF MEDICINE");
				
replace school="ST. ALEXIUS COLLEGE (FOR.DOCTORS CHSF,INC)" if inlist(school, "ST. ALEXIUS COLLEGE  (FOR.DOCTORS  CHSF,INC)",
				"ST. ALEXIUS COLLEGE (DOCTORS CHSF,INC)",
				"ST. ALEXIUS COLLEGE (FOR.DOCTORS CHSF.INC)");
				
							
*ST. DOMINIC COLLEGE OF ARTS AND SCIENCES IS NOW CALLED ST. DOMINIC COLLEGE OF ASIA (FOR. ST. DOMINIC C.A.S);
replace school="ST. DOMINIC COLLEGE OF ASIA (FOR. ST. DOMINIC C.A.S)" if inlist(school, "ST. DOMINIC COLLEGE OF ARTS AND SCIENCES");
				
replace school="ST. SCHOLASTICA'S COLLEGE OF HEALTH SCIENCES-TACLOBAN" if inlist(school, "ST. SCHOLASTICA'S COLLEGE OF HEALTH SCIENCES-TACL0BAN",
				"ST. SCHOLASTICA'S COLLEGE- TACLOBAN",
				"ST. SCHOLASTICA'S COLLEGE-TACLOBAN");
				
replace school="STA. CLARA DE MONTEFALCO COLLEGE, INC" if inlist(school, "STA. CLARA DE MONTEFALCO");
				
*EMPTY FACEBOOK PAGE AND ALUMNINET BUT FOUND IT LISTED IN BOOK OF WORLD LIST OF UNIVERSITIES;
replace school="STA. TERESITA SCHOOL OF NURSING" if inlist(school, "STA. TERESITA COLLEGE",
				"STA. TERESITA COLLEGE (NURSING & MIDWIFERY)");
				

*STI WEST NEGROS UNI IS IN BACOLOD CITY;
replace school="STI WEST NEGROS UNIVERSITY" if inlist(school, "STI COLLEGE - BACOLOD CITY");

*STI COLLEGE - ROXAS CITY,CAPIZ IS NOW CALLED DEAN ALBERTO VILLARRUZ COLLEGE;
replace school="DEAN ALBERTO VILLARRUZ COLLEGE" if inlist(school, "STI COLLEGE - ROXAS CITY,CAPIZ");	

generate temp=regexm(school, "^STI COLLEGE .* ROXAS CITY,CAPIZ$");
replace school="DEAN ALBERTO VILLARRUZ COLLEGE" if temp==1;
drop temp;

generate temp=regexm(school, "^STI COLLEGE .* STA. MARIA$");
replace school="STI COLLEGE - STA. MARIA" if temp==1;
drop temp;

generate temp=regexm(school, "^STI COLLEGE .* STA CRUZ, LAGUNA$");
replace school="STI COLLEGE- SOUTHERN LUZON- STA CRUZ" if temp==1;
drop temp;

replace school="STI COLLEGE - STA. MARIA" if inlist(school, "STI COLLEGE-STA. MARIA");

replace school="STI COLLEGE- SOUTHERN LUZON- CALAMBA" if inlist(school, "STI COLLEGE - CALAMBA, LAGUNA",
				"STI COLLEGE -CALAMBA, LAGUNA",
				"STI COLLEGE- CALAMBA, LAGUNA");
				
generate temp=regexm(school, "^STI COLLEGE .* CALAMBA, LAGUNA$");
replace school="STI COLLEGE- SOUTHERN LUZON- CALAMBA" if temp==1;
drop temp;

generate temp=regexm(school, "^STI COLLEGE .* MEYCAUAYAN$");
replace school="STI COLLEGE - MEYCAUAYAN" if temp==1;
drop temp;

replace school="STI COLLEGE - MEYCAUAYAN" if inlist(school, "STI COLLEGE- MEYCAUAYAN");

replace school="STI COLLEGE- CALOOCAN" if inlist(school, "SYSTEMS TECHNOLOGY INSTITUTE-CAL00CAN CITY");

replace school="STI COLLEGE- LEGAZPI" if inlist(school, "SYSTEMS TECHNOLOGY INSTITUTE-LEGAZPI");


*ON THE STI WEBSITE I FOUND THAT THE STI CAMPUS WAS CARMONA IN SOUTHERN LUZON;
replace school="STI COLLEGE- SOUTHERN LUZON- CARMONA" if inlist(school, "STI E-COLLEGE",
				"STI E-COLLEGE SOUTHWOODS",
				"STI E-COLLEGE SOUTHWOODS- CARMONA",
				"STI E-COLLEGE SOUTHWOODS-CARMONA");
				
generate temp=regexm(school, "^STI COLLEGE .* CAVITE$");
replace school="STI COLLEGE-CAVITE" if temp==1;
drop temp;

*CBT: Left "STI COLLEGES OF LUZON, INC" as missing because can't attritbute--tons of STI campuses;		
replace school= "STI COLLEGE OF SOUTHERN LUZON- LUCENA" if inlist(school, 
				"STI COLLEGE-LUCENA CITY",
				"STI COLLEGE -LUCENA CITY");
				
replace school= "STI COLLEGE- SOUTHERN LUZON- LUCENA" if inlist(school, "STI COLLEGE OF SOUTHERN LUZON- LUCENA",
				"STI COLLEGE - LUCENA CITY");
				
generate temp=regexm(school, "^STI COLLEGE .* LUCENA CITY$");
replace school="STI COLLEGE- SOUTHERN LUZON- LUCENA" if temp==1;
drop temp;
				
replace school="STI COLLEGE- SOUTHERN LUZON- ROSARIO" if inlist(school, "STI COLLEGE - ROSARIO CAMPUS",
				"STI COLLEGE -ROSARIO CAMPUS",
				"STI COLLEGE- ROSARIO CAMPUS");
				
generate temp=regexm(school, "^STI COLLEGE .* ROSARIO CAMPUS$");
replace school="STI COLLEGE- SOUTHERN LUZON- ROSARIO" if temp==1;
drop temp;
				
replace school="STI COLLEGE- MANILA- CUBAO" if inlist(school, "STI COLLEGE-CUBAO",
				"STI COLLEGE - CUBAO");
				
generate temp=regexm(school, "^STI COLLEGE .* CUBAO$");
replace school="STI COLLEGE- MANILLA- CUBAO" if temp==1;
drop temp;
				
replace school="STI COLLEGE- MANILLA- FAIRVIEW" if inlist(school, "STI COLLEGE- FAIRVIEW",
				"STI COLLEGE -FAIRVIEW",
				"STI COLLEGE - FAIRVIEW");
				
generate temp=regexm(school, "^STI COLLEGE .* FAIRVIEW$");
replace school="STI COLLEGE- MANILA- FAIRVIEW" if temp==1;
drop temp;
				
replace school="STI COLLEGE- MANILA- GLOBAL CITY" if inlist(school, "STI COLLEGE - GLOBAL CITY, TAGUIG",
				"STI COLLEGE -GLOBAL CITY, TAGUIG",
				"STI COLLEGE-GLOBAL CITY");
				
generate temp=regexm(school, "^STI COLLEGE .* GLOBAL CITY, TAGUIG$");
replace school="STI COLLEGE- MANILA- GLOBAL CITY" if temp==1;
drop temp;
				
generate temp=regexm(school, "^STI COLLEGE - LAS PI.*AS$");
replace school= "STI COLLEGE - LAS PINAS" if temp==1;
drop temp;

generate temp=regexm(school, "^STI COLLEGE .* LAS PI.*AS$");
replace school="STI COLLEGE- MANILA- LAS PINAS" if temp==1;
drop temp;

generate temp=regexm(school, "^STI COLLEGE-LAS PI.*AS$");
replace school="STI COLLEGE- MANILA- LAS PINAS" if temp==1;
drop temp;

replace school="STI COLLEGE- MANILA- LAS PINAS" if inlist(school, "STI COLLEGE - LAS PINAS");
				
replace school="STI COLLEGE- MANILA- MAKATI" if inlist(school, "SYSTEMS TECHNOLOGY INSTITUTE-MAKATI CITY",
				"STI COLLEGE -MAKATI CITY",
				"STI COLLEGE - MAKATI CITY");
				
generate temp=regexm(school, "^STI COLLEGE .* MAKATI CITY$");
replace school="STI COLLEGE- MANILLA- MAKATI" if temp==1;
drop temp;

replace school="STI COLLEGE- MANILA- RECTO" if inlist(school, "STI COLLEGE - RECTO",
				"SYSTEMS TECHNOLOGY INSTITUTE- RECTO",
				"SYSTEMS TECHNOLOGY INSTITUTE-RECTO");
				
generate temp=regexm(school, "^STI COLLEGE .* RECTO$");
replace school="STI COLLEGE- MANILA- RECTO" if temp==1;
drop temp;

replace school="STI COLLEGE OF MINDANAO- CAGAYAN DE ORO CITY" if inlist(school, "STI COLLEGE OF MINDANAO-CAGAYAN DE ORO CITY");
				
replace school="STI COLLEGE OF MINDANAO- DAVAO CITY" if inlist(school, "STI COLLEGE OF MINDANAO-DAVAO CITY",
				"STI COLLEGE OF  MINDANAO-DAVAO  CITY",
				"STI-COLLEGE OF MINDANAO-DAVAO CITY");

*STI COLLEGE OF WAS CUTOFF FOR 2010 December;
replace school="STI COLLEGE- MINDANO- ZAMBOANGA CITY" if inlist(school, "STI COLLEGE - ZAMBOANGA CITY",
				"STI COLLEGE -ZAMBOANGA CITY",
				"STI COLLEGE- ZAMBOANGA CITY",
				"STI COLLEGE OF");
				
generate temp=regexm(school, "^STI COLLEGE .* ZAMBOANGA CITY$");
replace school="STI COLLEGE- MINDANO- ZAMBOANGA CITY" if temp==1;
drop temp;
				
replace school="STI COLLEGE- NORTHERN LUZON- BAGUIO" if inlist(school, "STI COLLEGE - BAGUIO CITY",
				"SYSTEMS TECHNOLOGY INSTITUTE-BAGUIO CITY",
				"STI COLLEGE -BAGUIO CITY");
				
generate temp=regexm(school, "^STI COLLEGE .* BAGUIO CITY$");
replace school="STI COLLEGE- NORTHERN LUZON- BAGUIO" if temp==1;
drop temp;
				
replace school="STI COLLEGE- SOUTHERN LUZON- STA CRUZ" if inlist(school, "STI COLLEGE-STA CRUZ, LAGUNA",
				"STI COLLEGE - STA CRUZ, LAGUNA");
				
replace school="STI COLLEGE- SOUTHERN LUZON- SAN PABLO" if inlist(school, "SYSTEMS TECHNOLOGY INSTITUTE-SAN PABLO CITY",
				"STI COLLEGE SAN PABLO, INC");
				
replace school="STI COLLEGE- MUNOZ- EDSA" if inlist(school, "SYSTEMS TECHNOLOGY INSTITUTE-EDSA CROSSING");

replace school="STI COLLEGE- ORMOC" if inlist(school, "SYSTEMS TECHNOLOGY INSTITUTE-ORMOC");
				
replace school="SULTAN KUDARAT EDUCATIONAL INSTITUTION" if inlist(school, "SUITAN KUDARAT EDUCATIONAL INSTITUTION",
				"SULIAN KUDARAT EDUCATIONAL INSTITUTE",
				"SULTAN KUDARAT  EDUCATIONAL  INSTITUTION",
				"SULTAN KUDARAT EDUC'L INSTITUTE",
				"SULTAN KUDARAT EDUCATIONAL INSTITUTE");
				

*SURIGAO EDUCATION CENTER USED TO BE CALLED SURIAGO MEDICAL CENTER SCHOOL OF MIDWIFERY;				
replace school="SURIGAO EDUCATION CENTER" if inlist(school, "SURLGAO EDUCATION CENTER",
				"SURIGAO MEDICAL CENTER SCHOOL OF MIDWIFERY",
				"SURIGA0 EDUCATION CENTER");
				
*ASSUMED COLLEGE FOUNDATION,INC- ANGELES CITY(SPCCF) WAS PART OF THIS;				
replace school="SYSTEMS PLUS COLLEGE FOUNDATION,INC- ANGELES CITY(SPCCF)" if inlist(school, "SYSTEMS PLUS",
				"SYSTEMS PLUS  COLLEGE  FOUNDATION,INC-  ANGELES  CITY(SPCCF)",
				"SYSTEMS PLUS COLLEGE  FOUNDATION,INC-ANGELES  CITY(SPCCF)",
				"SYSTEMS PLUS COLLEGE FOUNDATION, INC-ANGELES CITY(SPCCF)",
				"SYSTEMS PLUS COLLEGE FOUNDATION,INC-ANGELES CITY(SPCCF)",
				"COLLEGE FOUNDATION,INC- ANGELES CITY(SPCCF)");
				
*SULTAN KUDARAT POLYTECHNIC STATE COLLEGE-TACURONG IS NOW CALLED SULTAN KUDARAT STATE UNIVERSITY-TACURONG;
replace school="SULTAN KUDARAT STATE UNIVERSITY-TACURONG" if inlist(school, "SULTAN KUDARAT POLYTECHNIC STATE COLLEGE-TACURONG");

*SURIGAO DEL SUR INSTITUTE OF TECHNOLOGY IS NOW CALLED SURIGAO DEL SUR ST UNI;
replace school="SURIGAO DEL SUR STATE UNIVERSITY" if inlist(school, "SURIGAO DEL SUR INSTITUTE OF TECHNOLOGY");
				
*FOUND THAT THIS IS NOW CALLED TAMARAW SECURITY TRAINING CENTER INC;
replace school="TAMARAW SECURITY TRAINING CENTER INC" if inlist(school, "TAMARAW TRAINING CENTER",
				"TAMARAW TRAINING CENTRE");
				
*FOUND THAT TANGUB CITY COLLEGES IS NOW CALLED GOV ALFONSO D TAN COLLEGE;
replace school="GOV ALFONSO D TAN COLLEGE" if inlist(school, "TANGUB CITY COLLEGES");

*TARLAC COLLEGE OF AGRICULTURE IS NOW CALLED TARLAC AGRICULTURAL UNIVERSITY;
replace school="TARLAC AGRICULTURAL UNIVERSITY" if inlist(school, "TARLAC COLLEGE OF AGRICULTURE");
				

replace school="TANCHULING COLLEGE" if inlist(school, "TANCHULING  COLLEGE",
				"TANCHULING COLLEGE (FORMERLY TANCHULING SCHOOL OF MIDWIFERY)");

replace school="TARLAC STATE UNIVERSITY  (TARLAC COLLEGE OF TECH.)" if inlist(school, "TARLAC STATE UNIVERSITY (FORMERLY TARLAC COLLEGE OF TECH.)",
				"TARLAC STATE UNIVERSITY (TARLAC COLLEGE OF TECH.)");

*ASSUMED TECARO SCHOOL OF MIDWIFERY WAS PART OF TECARO COLLEGE FOUNDATION;
replace school="TECARO COLLEGE FOUNDATION, INC." if inlist(school, "TECARO COLLEGE FOUNDATION, INC"
			"TECARO COLLEGE FOUNDATION. INC.",
			"TECARO COLLEGE FOUNDATION. INC.",
			"TECARO SCHOOL OF MIDWIFERY",
			"TECARD SCHOOL OF MIDWIFERY");
			
replace school="MARIAM SCHOOL OF NURSING" if inlist(school, "THE MARIAM SCHOOL OF NURSING, INC.");

replace school="THE PHILIPPINE WOMENS COLLEGE-ILOILO CITY" if inlist(school, "THE PHILIPPINE WOMENS COLLEGE - SARO, ILOILO CITY");
			
*TECARO IS ACTUALLY SPELLED TECARRO;
replace school="TECARRO COLLEGE FOUNDATION, INC" if inlist(school, "TECARO COLLEGE FOUNDATION, INC.");

*I ASSUMED MANILA TECHNOLOGICAL INSTITUTE WAS PART OF TECHNOLOGICAL INSTITUTE OF THE PHILIPPINES-MANILA;
replace school="TECHNOLOGICAL INSTITUTE OF THE PHILIPPINES-MANILA" if inlist(school, "MANILA TECHNICAL INSTITUTE");
			
			
replace school="THE FAMILY CLINIC, INC." if inlist(school, "THE FAMILY CLINIC, NC.",
				"THE FAMILY CLINIC. INC.");
				
replace school="GOOD SAMARITAN COLLEGE" if inlist(school, "THE GOOD SAMARITAN COLLEGES",
				"THE GOOD SAMARITAN COLLEGES - CABANATUAN CITY",
				"THE GOOD SAMARITAN COLLEGES-CABANATUAN CITY",
				"THE GOOD SAMARITAN COLLEGES- CABANATUAN CITY");
				
replace school="GOOD SAMARITAN COLLEGES" if inlist(school, "GOOD SAMARITAN COLLEGE");
				
*It was very hard to find info on this campus and the only trace of it I could find was it is listed on philippinenursingdirectory.com, otherwise no info and seems possible this campus isn't legit;				
replace school="THE GOOD SAMARITAN COLLEGES - CONCEPCION, TARLAC" if inlist(school, "THE GOOD SAMARITAN COLLEGES- CONCEPCION, TARLAC");
				
replace school="TOMAS CLAUDIO COLLEGES,INC.(FOR TOMAS CLAUDIO MEM. COL,INC)" if inlist(school, "TOMAS CLAUDIO MEMORIAL COLLEGE");

*I ASSUMED ROSARIO ACADEMY REFERS TO TOMAS DEL ROSARIO ACADEMY;
*TOMAS DEL ROSARIO ACADEMY IS NOW TOMAS DEL ROSARIO COLLEGE;
replace school="TOMAS DEL ROSARIO COLLEGE" if inlist(school, "TOMAS DEL",
				"TOMAS DEL ROSARIO ACADEMY",
				"ROSARIO ACADEMY");

generate temp=regexm(school, "^TRACE COLLEGE- LOS BA.*OS$");
replace school="TRACE COLLEGE-LOS BANOS" if temp==1;
drop temp;

generate temp=regexm(school, "^TRACE COLLEGE-LOS BA.*OS$");
replace school="TRACE COLLEGE-LOS BANOS" if temp==1;
drop temp;
				
replace school="TRINITAS COLLEGE- MEYCAUAYAN" if inlist(school, "TRINITAS COLLEGE-MEYCAUAYAN");
			
replace school="TRINITY-COLLEGE - QUEZON CITY" if inlist(school, "TRINITY - COLLEGE - QUEZON CITY",
				"TRINITY COLLEGE",
				"TRINITY COLLEGE - QUEZON CITY",
				"TRINITY COLLEGE OF QUEZON CITY",
				"TRINITY COLLEGE-QUEZON CITY",
				"TRINITY EDUCATIONAL INSTITUTE",
				"TRINITY UNIVERSITY OF ASIA (TRINITY-QC)");
			
replace school="UNCIANO COLLEGES & GENERAL HOSPITAL- MANILA" if inlist(school, "UNCIANO COLLEGES & GENERAL HOSPITAL-MANILA",
				"UNCIANO COLLEGE",
				"UNCIANO COLLEGES",
				"UNCIANO COLLEGES & GEN. HOSP.- MANILA(UNCIANNO PARAMEDICAL SCH",
				"UNCIANO COLLEGES & GEN. HOSP.- MANILA(UNCIANO PARAMEDICAL SCH",
				"UNCIANO COLLEGES & GEN. HOSP.-MANILA(UNCIANO PARAMEDICAL SCH",
				"UNCIANO COLLEGES & GEN. HQSP.-MANILA(UNCIANO PARAMEDICAL SCH");

replace school="UNCIANO COLLEGES & GENERAL HOSPITAL- ANTIPOLO" if inlist(school, "UNCIANO COLLEGE - ANTIPOLO",
				"UNCIANO COLLEGES & MEDICAL CENTER - ANTIPOLO",
				"UNCIANO COLLEGES & MEDICAL CENTER- ANTIPOLO",
				"UNCIANO COLLEGES & MEDICAL CENTER-ANTIPOLO",
				"UNCIANO COLLEGES S MEDICAL CENTER-ANTI POLO",
				"UNCIANO COLLEGES, INC - ANIPOLO",
				"UNCIANO COLLEGES, INC - ANTIPOLO");
				
replace school="UNCIANO PARAMEDICAL SCHOOL- ANTIPOLO" if inlist(school, "UNCIANO PARAMEDICAL SCHOOL - ANTIPOLO",
				"UNCIANO PARAMEDICAL SCHOOL ANTIPOLO",
				"UNCIANO PARAMEDICAL SCHOOL-ANTIPOLO",
				"UNCIANO PARAMEDICAL-SCHOOL - ANTIPOLO");
				
replace school="UNCIANO PARAMEDICAL SCHOOL-MANILA" if inlist(school, "UNCIANO PARAMED SCH",
				"UNCIANO PARAMEDICAL COLLEGE",
				"UNCIANO PARAMEDICAL COLLEGES",
				"UNCIANO PARAMEDICAL SCHOOL",
				"UNCIANO PARAMEDICAL SCHOOL - MANILA",
				"UNCIANO PARAMEDICAL SCIENCES");
				
				
*UNIVERSAL COLLEGE OF NURSING IS NOW CALLED UNIVERSAL COLLEGE;
replace school="UNIVERSAL COLLEGES OF PARANAQUE" if inlist(school, "UNIVERSAL COLLEGES OF  PARANAQUE",
				"UNIVERSAL COLLEGE OF NURSING");
				
generate temp=regexm(school, "^UNIVERSAL COLLEGES OF PARA.*AQUE$");
replace school="UNIVERSAL COLLEGES OF PARANAQUE" if temp==1;
drop temp;

*COLEGIO DE STA ISABEL IS NOW CALLED UNIVERSIDAD DE STA ISABEL;
replace school="UNIVERSIDAD DE STA ISABEL" if inlist(school, "COLEGIO DE STA. ISABEL",
				"COLEGIO DE STA. ISABEL COLLEGE (NAGA)",
				"COLEGIO DE STA. ISABEL NAGA",
				"COLLEGE DE SANTA ISABEL",
				"GOLEGIO DE SANTA ISABEL",
				"SANTA ISABEL COLLEGE",
				"UNIVERSIDAD DE SANTA ISABEL (COL DE STA ISABEL)",
				"UNIVERSIDAD DE SANTA ISABEL (COL. STA ISABEL)",
				"COLEGIO DE SANTA ISABEL");
				


*ZAMBOANGA A.E. COLLEGE IS NOW CALLED UNIVERSIDAD DE ZAMBOANGA;
*I assumed that the entry 'ZAMBOANGA' was part of Universidad de Zamboanga;
replace school= "UNVERSIDAD DE ZAMBOANGA" if inlist(school, "ZAMBOANGA A. E. COLLEGE",
				"UNIBERSIDAD DE ZAMBOANGA (ZAEC)",
				"UNIVERSIDAD DE  ZAMBOANGA  (FOR.ZAEC)",
				"ZAMBOANGA");
				

replace school = "UNIVERSITY OF THE ASSUMPTION" if inlist(school, "UNIVERSITY OF THE ASSUMP.");

*RAFAEL PALMA COLLEGE IS NOW CALLED UNIVERSITY OF BOHOL;
replace school="UNIVERSITY OF BOHOL" if inlist(school, "RAFAEL PALMA COLLEGE");

replace school="UNIVERSITY OF CEBU- BANILAD" if inlist(school, "UNIVERSITY OF CEBU-BANILAD");

replace school="UNIVERSITY OF CEBU IN LAPULAPU & MANDAUE" if inlist(school, "UNIVERSITY OF CEBU N LAPULAPU& MANDAUE");


replace school="UNIVERSITY OF CEBU (FORM. CEBU CENTRAL COLLEGES)" if inlist(school, "UNIVERSITY OF CE8U (FORMERLY CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CEBU",
				"UNIVERSITY OF CEBU (CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CEBU (FORMERLY CEBU CENTRAL COLLEGES)",
				"UNIVERSITY OF CEBU (FORMERLY. CEBU CENTRAL COLLEGES)");
				
*COLLEGE WEBSITE LISTS BOTH NAMES;		
*FOUND THAT PLM IS USED AS AN ACROYM FOR PAMANTASAN NG LUNGSOD NG MAYNILA; 		
replace school="UNIVERSITY OF THE CITY OF MANILA" if inlist(school, "PAMANTASAN NG LUKGSOD NG MAYNILA",
				"PAMANTASAN NG LUNGSOD NG MAYNIIA",
				"PAMANTASAN NG LUNGSOD NG MAYNILA",
				"PAMANTASANNG LUNGSOD NG MAYNILA",
				"PAMANTASAN KG LUNGS0D NG MAYNILA",
				"PAMANTASAN KG LUNGSOD NG MAYNILA",
				"P. L. M.");
				
replace school="UNION CHRISTIAN COLLEGE" if inlist(school, "UNION-CHRISTIAN COLLEGE");
				

replace school="UNIVERSITY OF THE CORDILLERAS" if inlist(school, "UNIVERSITY OF THE CORDILLERAS (BAGUIO COLLEGE FNDTN.)",
				"UNIVERSITY OF THE CORDILLERAS (FOR.BAGUIO C.F.)");
				
replace school="UNIVERSITY OF THE EAST - CALOOCAN" if inlist(school, "UNIVERSITY OF THE EAST-CALOOCAN");

replace school="UNIVERSITY OF THE EAST- MANILA" if inlist(school, "UNIVERSITY OF THE EAST",
				"UNIVERSITY OF THE EAST - MANILA",
				"UNIVERSITY OF THE EAST-MANILA");
				
*FEW OBSERVATIONS BUT SEEMS LEGIT;			
replace school="U. OF THE EAST RAMON MAGSAYSAY MEM MEDICAL CTR" if inlist(school, "U. OF THE EAST RAMON MAGSAYSAY HEM MEDICAL CTR",
				"U.E.R.M.M.M.C.");

*ASSUMED LA SALETTE COLLEGES FOUNDATION WAS PART OF THE UNI BECAUSE STARTED AS A COLLEGE AND THEN PROMOTED TO UNI;
replace school="UNIVERSITY OF LA SALETTE-SANTIAGO" if inlist(school, "LA SALLETE OF SANTIAGO",
				"UVERSITY OF LA SALLETE-SANTIAGO",
				"LA SALETTE COLLEGES FOUNDATION",
				"LA SALLETE COLLEGES FOUNDATION");
				
replace school="UNIVERSITY OF LUZON" if inlist(school, "UNIVERSITY OF LUZON (LUZON COLL.)",
				"LUZOH COLLEGES",
				"LUZON COLLEGE",
				"LUZON COLLEGES");
				
*PERPETUAL HELP COLLEGE RIZAL IS NOW CALLED UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA;
*The main campus for UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA is Las Pinas, so I assumed entries that just said Rizal were part of this campus;
replace school="UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA-LAS PINAS" if inlist(school, "PERP HELP COL-RIZAL",
				"PERPETUAL HELP COLLEGE - RIZAL",
				"PERPETUAL HELP COLLEGE OF RIZAL",
				"PERPETUAL HELP COLLEGE RIZAL",
				"PERPETUAL HELP COLLEGE-RIZAL",
				"PFRPETUAL HELP COLLEGE OF RIZAL",
				"PERPETUAL HELP COLLEGE OF RIZAL-LAS PINAS");
				
replace school="UNIVERSITY OF PERPETUAL HELP SYSTEM JONELTA- PANGASINAN" if inlist(school, "PERPERTUAL HELP COLLEGE OF PANGASINAN",
				"PERPETUAL COLLEGE OF PANGASINAN",
				"PERPETUAL HELP COLLEGE OF PANGASINAN");
				
replace school="UNIVERSITY OF PERPETUAL HELP SYSTEM-LAGUNA" if inlist(school, "UNIVERSITY OF PERPETUAL HELP SYSTEM-LAGUNA (FRY. PERP HLP COLLEGE",
				"UNIVERSITY OF PERPETUAL HELP SYSTEM-LAGUNA (PERP HELP COL)",
				"UNIVERSITY OF PERPETUAL HELP SYSTEN-LAGUNA (PERP HELP COL)");

*ASSUMED EASTERN PHILIPPINE COLLEGE WAS PART OF UNI OF EASTERN PHILIPPINES;
replace school="UNIVERSITY OF EASTERN PHILIPPINES- CATARMAN" if inlist(school, "UNIVERSITY OF EASTERN PHILIPPINES-CATARMAN",
				"UNIVERSITY OF EASTERN",
				"UNIVERSITY OF EASTERN PHILIPPINES",
				"EASTERN PHILIPPINE COLLEGE",
				"UNIVERSITY OF  EASTERN  PHILIPPINES-CATARMAN");
				
replace school="UNIVERSITY OF SAINT LA SALLE" if inlist(school, "UNIVERSITY OP SAINT LA SALLE");

replace school = "UNIVERSITY OF THE EAST RAMON MAGSAYSAY MEM MEDICAL CTR" if inlist(school, "UNIVERSITY OF THE EAST RAMON HAGSAYSAY MEM MEDICAL CTR",
				"UNIVERSITY OF THE EAST RAMON MAG SAYS AY MEM MEDICAL CTR",
				"UNIVERSITY OF THE EAST RAMON MAGSAYSAY HEM MEDICAL CTR",
				"UNIVERSITY OF THE EAST RAMON MAGSAYSAY MEDICAL CTR",
				"U. OF THE EAST RAMON MAGSAYSAY MEM MEDICAL CTR",
				"UNIVERSITY OF THE EAST RMMMC");
				
replace school = "PRES.R.MAGSAYSAY MEMORIAL HOSP.SCHOOL OF NURSING & MIDWIFERY" if inlist(school, 
				"PRES.R.MAGSAYSAY MEMORIAL HOSP.SCHOOL OF NURSING & MIDWIFERY",
				"PRES.R.MAGSAYSAY MEM. HOSP. SCH. OF NRSG. & MIDWIFERY",
				"R.MAGSAYSAY MEM. HOSP. SCH. OF NRSG. & MIDWIFERY");

*UNI OF ILOILO IS ON RIZAL ST;
replace school="UNIVERSITY OF ILOILO" if inlist(school, "ILOILO RIZAL COLLEGE");
				

replace school="UNIVERSITY OF THE IMMACULATE CONCEPTION- DAVAO" if inlist(school, "UNIVERSITY OF THE IMMACULATE CONCEPTION-",
			"UNIVERSITY OF THE IMMACULATE CONCEPTION-DAVAO",
			"UNIVERSITY OF THE  IMMACULATE  CONCEPTION-DAVAO",
			"UNIVERSITY OF IMMACULATE CONCEPTION-DAVAO");
			
			
replace school="UNIVERSITY OF LA SALETTE- SANTIAGO" if inlist(school, "UNIVERSITY OF LA SALETTE-SANTIAGO",
				"UNIVERSITY OF LA SALLETE - SANTIAGO",
				"UNIVERSITY OF LA SALLETE-SANTIAGO");
				
*UNIVERSITY OF MINDANAO - BANSALAN only has one observation but it it seems legit and opened in 1962;
				
replace school="UNIVERSITY OF MINDANAO- DAVAO CITY" if inlist(school, "UNIVERSITY OF MINDANAO-DAVAO CITY",
				"UNIVERSITY OF MIN DANAO-DAVAO CITY",
				"UNIVERSITY OF MINDANA-DAVAO CITY",
				"UNIVERSITY OF  MINDANAO-DAVAO  CITY");
				
replace school="UNIVERSITY OF NORTHERN PHILIPPINES-VIGAN" if inlist(school, "UNIVERSITY OF NORTHERN PHILIPPIHES-VIGAN",
				"UNIVERSITY OF  NORTHERN  PHILIPPINES-VIGAN");
				
replace school="UNIVERSITY OF REGINA CARMELI (REGINA CARMELI COLLEGE)" if inlist(school, "UNIVERSITY OF REGINA CARMELI (FRLY REGINA CARMELI COLLEGE)",
				"UNIVERSITY OF REGINA CARMELI (RESINA CARMELI COLLEGE)",
				"UNIVERSITY OF REGINA CARMELKI (FRLY REGINA CARMELI COLLEGE)",
				"UNIVERSITY OF REGINA CARMELI (FOR.REGINA CARMELI COLL)");
				
replace school="UNIVERSITY OF RIZAL SYSTEM- TAYTAY" if inlist(school, "UNIVERSITY OF RIZAL SYSTEM-TAYTAY");

replace school="UNIVERSITY OF RIZAL SYSTEM-TANAY" if inlist(school, "UNIVERSITY OF RIZAL SYSTEM (RIZAL SC)-TANAY");
			
replace school="UNIVERSITY OF MINDANAO- TAGUM" if inlist(school, "UNIVERSITY OF MINDANAO-TAGUM");

*CITY COLLEGE OF MANILA IS NOW CALLED UNIVERSIDAD DE MANILA;
replace school="UNIVERSIDAD DE MANILA (CITY COLLEGE OF MANILA)" if inlist(school, "CITY COLLEGE OF MANILA");

replace school="UNIVERSITY OF NEGROS OCCIDENTAL- RECOLETOS" if inlist(school, "UNIVERSITY OF NEGROS OCCIDENTAL-RECOLETOS");

*ASSUMED ENTRY WITHOUT SPECIFIC CAMPUS WAS PART OF MAIN CAMPUS;
replace school="UNIVERSITY OF NORTHERN PHILIPPINES-VIGAN" if inlist(school, "UNIVERSITY OF NORTHERN PHILIPPINES");

replace school="UNIVERSITY OF NORTHEASTERN PHILIPPINES" if inlist(school, "UNIVERSITY OF  NORTHEASTERN  PHILIPPINES",
				"UNIVO OF NORTHEASTERN PHILIPPINES",
				"U.N.E.P.");

replace school="UNIVERSITY OF PERPETUAL HELP- CAUAYAN CITY" if inlist(school, "UNIVERSITY OF PERPETUAL HELP-CAUAYAN CITY");

replace school="UNIVERSITY OF PERPETUAL HELP SYSTEM DALTA-LAS PINAS" if inlist(school, "UNIVERSITY OF PERPETUAL HELP RIZAL-LAS PINAS");

*THERE ARE 8 CONSTITUENT UNIVERSITIES FOR THE UNIVERSITY OF THE PHIL AND EACH CONSTITUENT HAS MULTIPLE LOCATIONS, FOR EXAMPLE VISAYAS IS A CONSTITUENT;
replace school="UNIVERSITY OF THE PHILIPPINES-VISAYAS-ILOILO CITY" if inlist(school, "UNIVERSITY OF THE PHILIPPINES - ILOILO");

replace school="UNIVERSITY OF THE PHILIPPINES - VISAYAS-TACLOBAN CITY" if inlist(school, "UNIVERSITY OF THE PHILIPPINES - TACLOBAN CITY",
			"UNIVERSITY OF THE PHILIPPINES-VISAYAS-TACLOBAN CITY",
			"UNIVERSITY OF THE. PHILIPPINES - TACLOBAN CITY");
			
*I DID NOT FIND THAT CEBU CITY WAS PART OF VISAYAS CONSTITUENCY;
replace school="UNIVERSITY OF THE PHILIPPINES - CEBU CITY" if inlist(school, "UNIVERSITY OF THE PHILIPPINES - VISAYAS-CEBU CITY");

			
replace school="UNIVERSITY OF THE PHILIPPINES SCHOOL OF HEALTH & SCIENCES- LEYTE" if inlist(school, "UNIVERSITY OF THE PHILIPPINES SCHOOL OF HEALTH & SCIENCES - LEYTE",
			"UNIVERSITY OF THE PHILIPPINES SCHOOL OF HEALTH & SCIENCES-LEYTE",
			"UNIVERSITY OF THE PHILIPPINES SCHOOL OF HEALTH &SCIENCES-LEYTE");
					
replace school="UNIVERSITY OF THE PHILIPPINES- DILIMAN" if inlist(school, "UNIVERSITY OF THE PHILIPPINES",
				"UNIVERSITY OF THE PHILIPPINES - DILIMAN");
			
*U.P. SCHOOL OF HEALTH & SCIENCES - LEYTE is a medical school supervised by the Uni of Phil-Maila and so I included them together;			
replace school = "UNIVERSITY OF THE PHILIPPINES- MANILA" if inlist(school, "UNIVERSITY OF THE PHILIPPINES-MANILA",
				"UNIVERSITY OF THE PHILIPPINES - MANILA",
				"UNIVERSITY OF THE PHIIIPPINES-MANILA",
				"U.P. - MANILA");
				
replace school = "UNIVERSITY OF THE PHILIPPINES- LEYTE" if inlist(school, 
				"U.P. SCHOOL OF HEALTH & SCIENCES - LEYTE",
				"U.P. SCHOOL OF HEALTH I SCIENCES - LEYTE",
				"UNIVERSITY OF THE PHILIPPINES SCHOOL OF HEALTH & SCIENCES- LEYTE",
				"UNIVERSITY OF THE PHILIPPINES SCHOOL OF HEALTH &SCIENCES-LEYTE");
				
replace school="UNIVERSITY OF SAN AGUSTIN" if inlist(school, "UNIVERSIT OF SAN AGUSTIN");
				
replace school="UNIVERSITY OF SAN CARLOS" if inlist(school, "UNIVERSITY OF SAN.CARLOS");

replace school = "UNIVERSITY OF SANTO TOMAS" if inlist(school, "UNIVERSITY OF SARTO TOMAS",
				"UNIVERSITY OF STO. TOMAS");

replace school = "UNIVERSITY OF SAN JOSE- RECOLETOS" if inlist(school, "UNIVERSITY OF SAN JOSE - RECOLETOS",
				"UNIVERSITY OF SAN JOSE-RECOLETOS");
				
*MINDANAO POLYTECHNIC COLLEGE AND DON MARIANO MARCOS MEMORIAL POLYTECHNIC STATE COLLEGE ARE NOW CALLED UNI OF SCI AND TECH OF SOUTHERN PHIL;
replace school="UNIVERSITY OF SCIENCE AND TECHNOLOGY OF SOUTHERN PHILIPPINES" if inlist(school, "MINDANAO POLYTECHNIC COLLEGE",
				"DON MARIANO MARCOS MEMORIAL POLYTECHNIC STATE COLLEGE");

				
*UNIVERSITY OF SOUTHERN PHIL IS NOW CALLED UNI OF SOUTHEASTERN PHIL;
*I ASSUMED SOUTHEASTERN COLLEGE - DAVAO MEANT UNI OF SE PHIL;
*CBT: University of Southern Philippines appears to be in Cebu, not Davao;
replace school="UNIVERSITY OF SOUTHEASTERN PHILIPPINES" if inlist(school, 
				"SOUTHEASTERN COLLEGE - DAVAO");
				
replace school = "UNIVERSITY OF THE SOUTHERN PHILIPPINES FOUNDATION" if school=="UNIVERSITY OF SOUTHERN PHILIPPINES";		
				

*MINDANAO INSTITUTE OF TECHNOLOGY NOW CALLED UNIVERSITY OF SOUTHERN MINDANAO;
replace school="UNIVERSITY OF SOUTHERN MINDANAO- KABACAN" if inlist(school, "UNIVERSITY OF SOUTHERN MINDANAO-KABACAN",
				"MINDANAO INSTITUTE OF TECHNOLOGY");

*FOUND THAT NORTH COTABATO COLLEGE OF ARTS & TRADE-KIDAPAWAN IS NOW CALLED UNI OF SOUTHERN MINDANAO;
replace school="UNIVERSITY OF SOUTHERN MINDANAO - KIDAPAWAN" if inlist(school, "UNIVERSITY OF SOUTHERN MINDANAO-KIDAPAWAN",
				"NORTH COTABATO COLLEGE OF ARTS AND TRADE - KIDAPAWAN",
				"NORTH COTABATO COLLEGE OF ARTS & TRADE-KIDAPAWAN");

*THE MAIN CAMPUS IS IN CEBU CITY SO I ASSUMED ENTRY WITHOUT LOCATION IS PART OF CEBU CITY;
replace school = "UNIVERSITY OF THE VISAYAS- CEBU CITY" if inlist(school,
				"UNIVERSITY OF THE VISAYAS - CE8U CITY",
				"UNIVERSITY OF THE VISAYAS - CEBU CITY",
				"UNIVERSITY OF THE VISAYAS-CEBU CITY",
				"UNIVERSITY OF VISAYAS",
				"UNIVERSITY OF THE VISAYAS");
				
*THE MAIN CAMPUS IS IN ILOILO;
replace school = "UNIVERSITY OF THE PHILIPPINES VISAYAS" if inlist(school, "UNIVERSITY OF THE PHILIPPINES VISAYAS");

*Also a branch in Cebu. Note: University of the Visayas and Uni of the Phil Visayas are different;
*The first has the main campus in Cebu, the second has the main campus in Iloilo;				
replace school = "UNIVERSITY OF THE PHILIPPINES VISAYAS- CEBU CITY" if inlist(school,
				"UNIVERSITY OF THE PHILIPPINES- VISAYAS-CEBU CITY",
				"UNIVERSITY OF THE PHILIPPINES-VISAYAS-CE8U CITY");
				
replace school="UNIVERSITY OF THE VISAYAS- GULLAS COLLEGE OF MEDICINE" if inlist(school, "GULLAS COLLEGE OF MEDICINE");

*CITY COLLEGE OF URDANETA IS NOW CALLED URDANETA CITY UNI;				
replace school = "URDANETA CITY UNIVERSITY (CCU)" if inlist(school, "URDANETA COLLEGE OF TECHNOLOGY",
				"URDANETA COMM COLLEGE",
				"URDANETA COMMUNITY COLLEGE",
				"CITY COLLEGE OF URDANETA");
				
replace school = "UNIVERSITY OF THE VISAYAS- MANDAUE CITY" if inlist(school, "UNIVERSITY OF THE VISAYAS-MANDAUE CITY",
				"UNIVERSITY OF THE VISAYAS - MANDAUE CITY");
				
replace school="UNVERSIDAD DE ZAMBOANGA" if inlist(school, "UNIVERSIDAD DE ZAMBOANGA (FOR.ZAEC)",
				"UNIVERSIDAD DE ZAMBOANGA (ZAEC)");

*FOUND THAT SOUTHERN ISLAND HOSPITAL-CEBU CITY IS NOW CALLED VICENTE SOTTO MEMORIAL MEDICAL CENTER;
replace school="VINCENTE SOTTO MEMORIAL MEDICAL CENTER" if inlist(school, "SOUTHERN ISLAND HOSPITAL-CEBU CITY");
				
replace school = "URIOS COLLEGE" if inlist(school, "URIOS COLTEGE");

*FOUND THAT LEYTE STATE UNI IS NOW PART OF VISATAS STATE UNI;
replace school = "VISAYAS STATE UNIVERSITY- BAYBAY" if inlist(school, "VISAYAS STATE UNIVERSITY (FOR.VISCA,LSU.)- BAYBAY",
				"VISAYAS STATE UNIVERSITY (FOR.VISCA,LSU.)-BAYBAY",
				"VISAYAS STATE UNIVERSITY (FOR.VISCA.LSU.)-BAYBAY",
				"LEYTE STATE UNIVERSITY (VISCA)-BAYBAY",
				"LEYTE STATE UNIVERSITY (VISZA)-BAYBAY");
				
replace school = "VIRGEN MILAGROSA UNIVERSITY" if inlist(school, "VIRGEN MILAGROSA  UNIVERSITY  FOUNDATION",
				"VIRGEN MILAGROSA E.I",
				"VIRGEN MILAGROSA EDUCATIONAL INSTITUTE",
				"VIRGEN MILAGROSA EDUCATIONAL INSTITUTIONS"
				"VIRGEN MILAGROSA UNIVERSITY FOUNDATION",
				"VIRGEN MILAGROSA UNIVERSITY FOUNDATION",
				"V.MILAGROSA EDUCATIONAL INSTITUTIONS");
				
*CEBU VELEZ CENTRAL HOSPITAL SCHOOL OF NURSING IS NOW VELEZ COLLEGE;
replace school = "VELEZ COLLEGE" if inlist(school, "VELEZ COLLEGE OF NURSING",
				"CEBU VELEZ CENTRAL HOSPITAL SCHOOL OF NURSING",
				"CEBU VELEZ CENTRAL HOSP. SCH. OF NURSING",
				"CEBU VELEZ HOSPITAL SCHOOL OF NURSING",
				"CEBU-VELEZ CENTRAL HOSPITAL SCHOOL OF NURSING",
				"CEBU VELEZ COLLEGE");

replace school="VIRGEN DE LOS REMEDIOS MEDICAL CENTER SCHOOL" if inlist(school,"V.DE LOS REMEDIOS MEDICAL CENTER SCHOOL");

*VISAYAN MARITIME ACADEMY IS NOW CALLED VMA GLOBAL COLLEGE;
replace school="VMA GLOBAL COLLEGE" if inlist(school, "VMA GLOBAL COLLEGE (VISAYAN MARITIME ACADEMY)",
				"VISAYAN MARITIME ACADEMY");
				
replace school="XAVIER UNIVERSITY" if inlist(school, "ATENEO DE CAGAYAN",
		"XAVIER UNIVERSITY (FORMERLY ATENEO DE CAGAYAN)", 
		"XAVIER UNIVERSITY ATENEO DE CAGAYAN");
		
replace school="UNIVERSITY OF SAINT LOUIS-TUGUEGARAO" if inlist(school, "UNIVERSITY OF SAINT LOUIS- TUGUEGARAO",
		"ATENEO DE TUGUEGARAO");

replace school = "WORLD CITI COLLEGES - ANTIPOLO" if inlist(school, "WORLD CITI  COLLEGES-ANTIPOLO,  INC.",
				"WORLD CITI COLLEGES - ANTIPOLO, INC.",
				"WORLD CITI COLLEGES- ANTIPOLO, INC.",
				"WORLD CITI COLLEGES-ANTIPOLO, INC.",
				"WORLD CITI COLLESES-ANTIPOLO, INC.");
				
replace school = "WORLD CITI COLLEGES - QUEZON CITY" if inlist(school, "WOLD CITY COLLEGES (QUEZON CITY M.C.C)",
				"WORLD CITI COLLEGES (QUEZON CITY M.C.C)",
				"WORLD CITI COLLEGES, QUEZON CITY(QUEZON CITY M.C.C)");
				

replace school = "WESTERN COLLEGES- CAVITE" if inlist(school, "WESTERN COLLEGES - CAVITE",
					"WESTERN COLLEGES-CAVITE");

replace school = "WESTERN LEYTE COLLEGE- ORMOC" if inlist(school, "WESTERN LEYTE COLLEGE-ORMOC");

*WESTERN MINDANAO STATE U- AURORA only has one observation but it seems legit;

replace school = "WESTERN MINDANAO STATE UNIVERSITY-PAGADIAN CITY" if inlist(school, "WESTERN MINDANAO STATE U- PAGADIAN CITY",
					"WESTERN MINDANAO STATE U-PAGADIAN CITY");
					
replace school = "WESTERN MINDANAO STATE UNIVERSITY-ZAMBOAGNA CITY" if inlist(school, "WESTERN MINDANAO STATE U- ZAMBOANGA CITY",
					"WESTERN MINDANAO STATE U-ZAMBOANGA CITY",
					"WESTERN MINDANAO STATE UNIVERSITY- ZAMBOANGA CITY");
					
replace school = "WESTERN MINDANAO STATE UNIVERSITY-MARAWI CITY" if inlist(school, 
					"WESTERN MINDANAO STATE UNIVERSITY",
					"W. MINDANAO STATE U");
					
replace school = "WEST VISAYAS STATE UNIVERSITY- LA PAZ" if inlist(school, "WEST VISAYAS STATE UNIVERSITY LA PAZ",
				"WEST VISAYAS STATE UNIVERSITY-LA PAZ",
				"WEST VISAYAS STATE UNIVERSITY - LA PAZ",
				"WEST VISAYAS STATE UNIVERSITY",
				"WEST VISAYAS STATE U");
				
replace school = "WESLEYAN UNIVERSITY-PHILIPPINES-CABANATUAN CITY" if inlist(school, "WESLEYAN UNIVERSITY",
				"WESLEYAN UNIVERSITY OF THE PHILIPPINES",
				"WESLEYAN UNIVERSITY OF THE PHILIPPINES- CABANATUAN CITY",
				"WESLEYAN UNIVERSITY OF THE. PHILIPPINES",
				"WESLEYAN UNIVERSITY- PHILIPPINES- CABANATUAN CITY",
				"WESLEYAN UNIVERSITY-PHILIPPINES",
				"WESLEYAN UNIVERSITY- PHILIPPINES-CABANATUAN CITY");
				
replace school = "WESLEYAN UNIVERSITY-PHILIPPINES-MARIA AURORA" if inlist(school, "WESLEYAN  UNIVERSITY-  PHILIPPINES-MARIA  AURORA",
				"WESLEYAN UNIVERSITY- PHILIPPINES-MARIA AURORA");
				
				
				
replace school = "WEST VISAYAS STATE UNIVERSITY- LA PAZ" if inlist(school, "WESTERN VISAYAS COLLEGE OF SCIENCE & TECHNOLGGY-LA PAZ",
				"WESTERN VISAYAS STATE COLLEGE",
				"WESTERN VISAYAS STATE UNIVERSITY");
					
*Schools starting with Z;

*This school seems to exist, but the only programs associated with the school that I could find were Aircraft Maintenance Techincian and Computer Hardware Servicing;
replace school= "ZAMBOANGA INSTITUTE OF AVIATION AND TECHNOLOGY" if inlist(school, "ZAMBOANGA INSTITUTE OF TECHNOLOGY");

*Zamboanga School of Arts and Trades is now called Zamboanga City State Polytechnic College;
*Despite the low number of observations, this institution seems legit and the facebook page has been updated recently; 
replace school= "ZAMBOANGA CITY POLYTECHNIC COLLEGE" if inlist(school, "ZAMBOANGA SCHOOL OF ARTS AND TRADES");
					
*ZAMBOANGA STATE COLLEGE OF MARINE SCIENCES & TECHNOLOGY this school exists, but on the college website there are no nursing programs;
*The majority of programs associated with this institution are in fisheries, maritime and marine biology;
*The only programs they have that I found could be relevant are BS Secondary Education major in English or Home Economics;

*College inc was cut off in the PDF conversion. The actual entries were preserved and cleaned;
drop if school=="COLLEGE, INC";
*School was from DAVAO MEDICAL SCHOOL FOUNDATION in 2009 and Perpetual Help Paramedical School in 2010. PDF page break split into two entries. Numbers are preserved;
drop if school=="SCHOOL";
*Same with Northern Negros State College of Science and Technology;
drop if school=="SCIENCE & TECHNOLOGY";
